Skip to Content
author's profile photo Former Member
Former Member

MIN Value that ignores 0

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2009 at 08:36 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.