MIN Value that ignores 0

[Former Member]

Hello, experts - need your help.

I have KF defined as MIN. When I run BEX report for the lowest level (customer, material, time) I see a lot of 0 which is fine. When I try to aggregate to the next level (material, time) it still shows 0.

How do I aggregate my KF in BEX report to show minimum actual value in the group and not 0?

I tried to suppress zeroes but that did not work - shows empty cells instead of 0 and that's not what I want.

Thank You!

Alina

[Former Member · Accepted solution]

Applying a condition (at appropriate drill down level) will suppress zeroes (condition should say KF <> 0)..

Which is to say - it will remove rows with zero value (not suppress zeroes with blank).

Edited by: Ajay Das on Aug 11, 2009 1:36 PM

[Former Member · Accepted solution]

Thank You for the reply. As I understand, condition will remove entire row and there are other Key Figures - so I can't eliminate entire row. Is there anything else I can do?

[Former Member · Accepted solution]

Put a condition in the query to bring KF only >0. And then use MIN function, which will give you only the minimum value>0.

Does this help?

Thanks

Sachin

[Former Member · Accepted solution]

A crude workaround will be to replace the zeroes with a high enough no (say 9999....) using a formula KF. This will get your min right in aggregated view.

It will show 9999 in the detailed view which might be an issue.