Table calculation's value based on other calculation

Looker Q&A Looker
1

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

image.png

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.

2

Can you try is_null(${calculation_1})?

3

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!

2 Likes