It seems like it should be a simple solution, but my brain is tired!
I am using a rollup field to show the total discount so I can highlight it on a quote which I have made with page designer. If there is no discount ($0.00) I don't want it to show on the quote. So I am trying to figure out how to leave it blank when there is result is $0. I tried adding another field with a formula, but then I can't get a positive number to be in currency format, just a string.
I tried doing an IF Aggregation formula but kept getting an error.
I made sure that the source field (Amt Saved) does not return anything if the result is 0 hoping that would follow through to the rollup, but no luck.
Can someone please help?