Skip to Content

How to hide/eliminate a row if a particular key figure value is 0

Wanted to hide/eliminate a row if a particular key figure value is 0.

As shown in the screenshot, if Key Figure 1 value is 0 (Zero), and even if other key figures have some values, Wanted to to hide/eleminate a row.

Please help with the solution for the above issue

key-figure-1.jpg (64.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 30, 2017 at 03:51 AM

    Hi,

    I won't recommend using a condition since it will affect your RESULT values.

    What I will suggest is to create a FORMULA or CKF for your KF2, KF3, KF4, and KF5.

    CKF2 = (KF1 == 0) * 0 + KF2

    CKF3 = (KF1 == 0) * 0 + KF3

    CKF4 = (KF1 == 0) * 0 + KF4

    CKF5 = (KF1 == 0) * 0 + KF5

    You will have a value of ZERO for KF2 to KF5 if your KF1 is ZERO.

    Afterwards, you may apply the SUPPRESSION OF ZERO in ROWS.

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Loed,

      your formula will not work like you put it there, use in stead =(KF1 <> 0)*KF2

      secondly condition is not mixing up with your endresult like you stated, check out screenshot

      so your suggestion will result in the same output when using a condition when you'll set the suppression of zero's

      capture.png (26.2 kB)
  • Sep 29, 2017 at 10:51 AM

    hi,

    you can set a condition on that keyfigure!

    grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded