9 Replies Latest reply: Oct 11, 2016 6:53 PM by Sunny Talwar

# How to filter out zero dollar values in a Sum using Set Analysis

I have a set analysis expression that calculates the Sum of the value Amount:

=Sum({\$<[FY]={\$(vFY)}, [Division]={'A','B','C','D','E','F'}>} [Amount])

I do not want to see the values that are equal to \$0.00  How can I filter those out?

• ###### Re: How to filter out zero dollar values in a Sum using Set Analysis

May be check 'Suppress zero values' on the presentation tab of your chart properties?

• ###### Re: How to filter out zero dollar values in a Sum using Set Analysis

This is in a straight table and I do have Suppress Zero-Values checked.

• ###### Re: How to filter out zero dollar values in a Sum using Set Analysis

Could the value be very small like 0.00000000012 or something like that?

• ###### Re: How to filter out zero dollar values in a Sum using Set Analysis

I suppose that is possible, but I don't think so.

• ###### Re: How to filter out zero dollar values in a Sum using Set Analysis

Not sure I understand your issue.

Could you post some more details (chart dimensions, other expressions, a screenshot etc)?

Or could you post a small sample QVW?

• ###### Re: How to filter out zero dollar values in a Sum using Set Analysis

I have data in a straight table.  I do not want to see the Sums that equal \$0.00

=Sum({\$<[FY]={\$(vFY)}, [Division]={'A','B','C','D','E','F'}>} [Amount])

Division     Period     FY     BU     Amount

A               11          16     123     \$100,000

A               11          16     345     \$200,000

B               11          16     678     \$0.00

B               11          16     901     \$500,000

C               11          16     123     \$0.00

C               11          16     345     \$450,000

• ###### Re: How to filter out zero dollar values in a Sum using Set Analysis

And 'Suppress zero values' is enabled on presentation tab?

And Amount field values are integer values?

(you could also try for now using

=Round( Sum( ... Amount))

, if this makes any difference)

• ###### Re: How to filter out zero dollar values in a Sum using Set Analysis

Cliff, can you share a sample QVW showing this behaviour, as your expression together with the "suppress zero values" option works as expected when I try to replicate your issue.

S.

• ###### Re: How to filter out zero dollar values in a Sum using Set Analysis

Would be difficult to know what is wrong unless we see the issue. Would you be able to share screenshots at least?