Can't suppress zero values when using rank function

[Anonymous]

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.

[MK_QSL]

Could you please post your example?

[Anonymous]

Here is an example of the table in Excel.

[MK_QSL]

can you post QVW?

[Anonymous]

Here is an example QVW.