Good Morning!
I am currently working on a few forms and one of the requests is to make sure that if the discount is showing 0% to remove it from the form. The title “Discount” can still be there but the number needs to go away.
Currently I have =IIF (Null ([ARTran.DiscPct]) ,'', [ARTran.DiscPCT]) . I feel like I’m close but I know I’m missing something. This is being done on the Sales Order invoice but will also be applied to others.
Any help would be appreciated.
Thanks,
Brent
Best answer by darylbowman
Remove the parenthesis after [ARTran.DiscPct])
+15
=IIF ([ARTran.DiscPct]) = 0 ,'', [ARTran.DiscPCT])
+15Better yet
=IIf(IsNull([ARTran.DiscPct],0)=0 ,'',[ARTran.DiscPct])
Thank You guys! I get an error when entered and previewing the report. Is this normal?
Syntax error in the expression. Context: TextBox ‘TextBox39’ property ‘Value’
Brent
So I was working on this a little more today. This was on a different from and received the same error. Here is the properties box. Should anything look different?
+15Remove the parenthesis after [ARTran.DiscPct])
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
