Problem with graphic and null values

[#1]

Hi everybody.

I'm having problems with null values in a graphic. The problem is this:

I have null values in my data. In the pivot table i can use the option "dont show null values"

but in the graphic, in the tag part, i can't do that.

For example in the pivot table i have "Total: 75000", in the graphic i have "Total:75200" (for the nulls)

I tried IF not is null(SUM(quantity)) but it's not working.

have i made myself clear?

Greetings!

[jpenuliar]

Hi,

Try below Set Analysis:

Sum({<YourFieldshowingnull = {'*'}-{''}>}Quantity)

[#3]

Hi!

Im not sure if i understood.

This should be like this ?

Sum({<NULL FIELD = WHAT'S THIS?  {'*'}-{''}>} QUANTITY)

[#4]

It's Woking! Thank you.

But would you please explain the {'*'}-{''} part?

Greetings!

[jpenuliar]

This should be the field you used as Dimension

try your field "Razon social" or with "?olicitante".

[jpenuliar · Accepted solution]

It's basically "All except null" modifier.

more readings in the attached.