Showing right values according to set analysis

[linoyel]

Hey all, I really need your help

I have to show sum of sales for agents who sold less then 10000 (and a few more conditions in set analysis).

It lookls like this:

=If ($(NetSum_upgrade_current)<=10000, Sum({$<$(s.Month.Current), SaleType_id = {0}, user_group_ID = {1}>} income), 0)

As you can see, if the condition is false (for example, agent who sold > 10000),  I put value = 0 and then I check "suppress zero values" so it won't be shown in a table.

The problem is agents that sold 0! When it's a real 0 and not 0 because of the false condition - I need them to be in the table as well!

Is there any option to change 0 by smth else in the condition, lets say by -11111 and then suppress this value?

Any help would be appreciated

[avinashelite · Accepted solution]

Hi Linoy,

Replace 0 by some thing like '' and try with suppress missing.

[linoyel]

Thank you very much, Avinash!

That worked