How to resolve this error?

[bhaveshp90]

Hello,

I have a table a shown below;

I am calculating YTD as Current month - Baseline columns. But the yellow marked value is wrong (-32864-0 = -32864).

Why is my value showing as -? Any help

[lironbaram]

hi

the problem is that the value is missing it's not zero

and you can't do a calculation with missing values

[bhaveshp90]

Yes it is missing, Is there a way to avoid it. even my expression If(Variance_YTD = ' ', 0, xxxxxxx) not working.

[MarcoWedel · Accepted solution]

RangeSum(Current month, - Baseline)

[bhaveshp90]

thank you Marco, it worked like a charm.

[bhaveshp90]

We can also use if(isnull(field), 0, xxx).