Table calculation's value based on other calculation

Dawid
Participant V

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 60
2 REPLIES 2

Can you try is_null(${calculation_1})?

Dawid
Participant V

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!

Top Labels in this Space
Top Solution Authors