I assume that when you bring the Calculation 2 and Calculation 3 into your canvas they are aggregated using SUM.
In which case you'll need to also wrap your difference in SUMs too
SUM([Calculation3]) - SUM([Calculation2])
Hope that does the trick
It worked. I tried using SUM before posting this in forum and it don't work that time. But now its worked.
I used Zn and its working.
So if you just want to treat them as zeros, you can just wrap your Calcs in
Ah just seen you’ve found that!!
You could have instead put an else statement to 0 in your original formulas
If =“something” then else 0 end
On Sat, 15 Sep 2018 at 09:19, chandrakanth k <email@example.com>