dkmoreland
Registered User.
- Local time
- Today, 00:05
- Joined
- Dec 6, 2017
- Messages
- 129
I know you folks have seen this question a hundred times but I need to ask it anyway.
On my report, if the shipped quantity is equal to the order quantity, I need it to display 0 in the field. If it is not equal to the order quantity, I need it to display the value of the shipped quantity.
Here's my code for the field:
I'm getting a #type error - both fields are number fields. I'm also getting a circular reference error.
Is my Iif statement incorrect or did I miss something else?
BTW - I know the field names are funky - I inherited this system.
Thanks in advance for any and all insight.
On my report, if the shipped quantity is equal to the order quantity, I need it to display 0 in the field. If it is not equal to the order quantity, I need it to display the value of the shipped quantity.
Here's my code for the field:
Code:
Iif([Shipping Qty:] <> [Order Quantity],[Shipping QTY:], 0)
I'm getting a #type error - both fields are number fields. I'm also getting a circular reference error.
Is my Iif statement incorrect or did I miss something else?
BTW - I know the field names are funky - I inherited this system.
Thanks in advance for any and all insight.