Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to remove an all fields from a straight table for when the quantity is 0.
The expression for Quantity is: sum([Vehicle Rev Qty])
The only way I know how to usually remove them is by ticking 'Suppress Zero Values', but that isnt doing anything in this occasion.
Any ideas on the best way to do it?
Do you have more than one expressions? May be you need to force the other values in this row to be null or 0 also. Let Say you have another expression as Count(Measure)... you can do like this
If(Sum([Vehicle Rev Qty]) > 0, Count(Measure))
Repeat this for all your expresisons... and then 'Suppress Zero Value' should work
May be try below one
sum({<YourDimensionName = {"=SUM([Vehicle Rev Qty])>0"}>}[Vehicle Rev Qty])
Do you have more than one expressions? May be you need to force the other values in this row to be null or 0 also. Let Say you have another expression as Count(Measure)... you can do like this
If(Sum([Vehicle Rev Qty]) > 0, Count(Measure))
Repeat this for all your expresisons... and then 'Suppress Zero Value' should work
Hi,
1. Uncheck "Show All Values" Check box if it is checked for any of the Dimensions.
2. Uncheck the Suppress Zero-Values
If you still see the values, share the app or image.
Hi,
Can you try to show Conditionally, like
if(Quantity>=1,1,0)
Regards
Sathish
This works great thanks Sunny! Is there a way I can get it to only show results when the quantity is above 0? As its given me some negative results that I dont need
That is strange because I was looking for only quantities above 0
If(Sum([Vehicle Rev Qty]) > 0, Count(Measure))
Did you check with <> may be?