I discovered a very weird behaviour and not sure if it’s just me.
The first calculation is just offset(${measure}, 1}
, the second calculation is ${calculation_1} = null
As you can see the last row has NULL
in the first calculation but returns no
in the second calculation.
I tried with zero 0
as well but to no avail. Right now I just used > 0
but I still don’t know what value of what type is returned by the function here.
Can you try is_null(${calculation_1})
?
Yeah I keep forgetting about that function. Mostly because = null
doesn’t return any warning or anything that would trigger my mindset change to use it. Thanks!