Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be check 'Suppress zero values' on the presentation tab of your chart properties?
This is in a straight table and I do have Suppress Zero-Values checked.
Could the value be very small like 0.00000000012 or something like that?
I suppose that is possible, but I don't think so.
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?
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
Amount is your only expression?
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)
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.
Would be difficult to know what is wrong unless we see the issue. Would you be able to share screenshots at least?