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

Capture.PNG
(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?


image


image




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


Login or Signup to post a comment