This content has been marked as final.
Show 2 replies

1. Re: Calculated fields/Replacing a zero with a blank
jens.bruckmann Feb 12, 2016 2:54 AM (in response to Eric Horio)Hi,
have you tried
sum([Pipe Created])sum([Pipe Won])?

2. Re: Calculated fields/Replacing a zero with a blank
pooja.gandhi Feb 12, 2016 5:43 AM (in response to Eric Horio)1 of 1 people found this helpfulEric!
There has to be value in 'pipe won' for it to subtract. It will not perform the subtraction calc when it is 'null'. Change the formulas for your pipe created and pipe won to this:
Pipe Created: IFNULL(IF [Stage] <> 0 THEN [Amount] END,0)
Pipe Won: IFNULL(IF [Stage] = 10 THEN [Amount] END,0)
Then the subtraction calc should work correctly: