qmem://<builtin>

[#1]

I am using qmem://<builtin> in a pivot table to show some arrows. The problem is that without the expression for the arrows, zero values are suppressed as they should be. But as soon as I put in the expression for the "arrows", zero values are no longer being suppressed.  Any ideas why?

Thanks,

Stephen

[Miguel_Angel_Baeyens · Accepted solution]

Hi Stephen,

You should create an If() so when there is result, the arrow appears, and when there's not (zero, null, missing) null() is shown instead of the arrow.

Is that what it's happening?

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica