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.

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

• 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

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