CODEWITHSUNDEEP
crystal-reports
Nurman Ade
Nurman Ade

Reputation: 31

Crystal Report Formula If then else

I am trying to find the way how to remove 2 digit decimals in field purchaseorder.UPRI when purchaseorder.CUR = "IDR". The way that I have tried does not help me to solve myproblem How do I fix it ? Does anyone here could help me to solve the problem ? Here is my code;

IF{purchaseorder.CUR} = "IDR" 
IF(ROUND({purchaseorder.UPRI},0) <> {purchaseorder.UPRI}) THEN
(
    2
)
ELSE
(
    0
)

Upvotes: 0

Views: 82

Answers (1)

heringer
heringer

Reputation: 3208

I can't try it right now, but try these options and tell me if it worked:

if {purchaseorder.CUR} = "IDR" 
then Truncate({purchaseorder.UPRI})

Upvotes: 1

Related Questions