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
+16
=IIF ([ARTran.DiscPct]) = 0 ,'', [ARTran.DiscPCT])
+17Better 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?
+17Remove the parenthesis after [ARTran.DiscPct])
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
