Start a new topic

Dollar Discount Amount ".if."

I have a formula that shows the dollar amount of price modifier discount, but Is there a way for it to only show if the discount is more that $0.00?

The current formula I am using: .if.documentitems->pricemodifier<>"".then.documentitems->extendedlist-documentitems->extendedprice

(3.34 KB)

Tricky, because we're mixing numbers (the value we're calculating) and text (price modifier="") - QW isn't a fan of that.

Would simply 'suppressing zero values' work, or would you sometimes have negative values in that calculation?



This worked, thankyou!!! I cant believe I did not notice that. 

Login or Signup to post a comment