Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm using the Rank function below so if the value of Quantity is not 0 then the rank function is used but if the value of Quantity is zero then zero is used. I've checked the "Suppress Zero-Values" on the Presentation tab so these rows should be hidden. This is not working when the rank function is used.
=if([Quantity] <> 0,rank(sum([qty-prod])),0)
Here is an example of my table. The Row's displaying all zeros should not be displayed.
Could you please post your example?
Here is an example of the table in Excel.
can you post QVW?
Here is an example QVW.