Skip to Content
0

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

Sep 28, 2017 at 02:39 PM

59

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Loed Despuig Sep 30, 2017 at 03:51 AM
0

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


delete.jpg (66.3 kB)
Show 1 Share
10 |10000 characters needed characters left 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)
0
Koen Hesters Sep 29, 2017 at 10:51 AM
0

hi,

you can set a condition on that keyfigure!

grtz

Koen

Share
10 |10000 characters needed characters left characters exceeded