Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Just downloaded the 2019 Sense app and like the new extension P&L pivot chart extension. one problem I have is that I can't exclude nulls/ Zero values. I can de-select the Include null vales against the dimension, but the add-ons Data handling include zero values is missing.
Thanks for your help
Hi,
Did you ever find a solution?
You can create a calculated field in the script that has a value of 1 where the field is not null, and then in the set analysis put:
{<IsNotNull={1}>}