have you tried
sum([Pipe Created])-sum([Pipe Won])?
1 of 1 people found this helpful
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: