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.
Caylin Murray
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