Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Rollup - Leave Blank if 0

Topic Labels: Formulas
Solved
Jump to Solution
1686 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Leah_Relish
6 - Interface Innovator
6 - Interface Innovator

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? 

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

This will work!

IF(values,SUM(values))

 

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

This will work!

IF(values,SUM(values))

 

So, you know, I tried that...several times. And kept getting an error. But alas today it works - must have been typing it wrong. Thank you!!!