P&L pivot chart extension Exclude Null / Zero Values

[ccsimo16]

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

[stha142020]

Hi,

Did you ever find a solution?

[sonkumamon]

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}>}