Discussion board where members can get started with QlikView.
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
Go to Solution.
RangeSum(Current month, - Baseline)
the problem is that the value is missing it's not zero
and you can't do a calculation with missing values
Yes it is missing, Is there a way to avoid it. even my expression If(Variance_YTD = ' ', 0, xxxxxxx) not working.
thank you Marco, it worked like a charm.
We can also use if(isnull(field), 0, xxx).