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.