Table calculation's value based on other calculation

I discovered a very weird behaviour and not sure if it’s just me.

image

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.

0 2 103
2 REPLIES 2
Top Labels in this Space