Skip to Content
0

Leave cell blank in report painter

Feb 02, 2017 at 09:36 AM

48

avatar image

Hello,

my report painter rows contains GL account set and my 2 columns are defined by company code.

I need to leave specific cells blank so that the data will not be presented. something like this:

C. code A | C. code B

GL account 10.00 USD | <leave blank>

This setting needs to be applied to many rows in the report, so I am not looking for a solution based on a Z-cells and a new section based on calculated key figures.

Any idea will be appreciated!

Thanks,

Yoel.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Kanishka De Silva May 22, 2017 at 03:56 AM
0

Hi Yoel Tovi,

If you need the whole row to be left blank, the easiest way is to insert a formula which ultimately gives the value zero. for example, you could deduct a row value from that same row value, therefore the answer would be zero.

by doing so, on the final output, your desired row would be blank.

Regards,

Kanishka

Share
10 |10000 characters needed characters left characters exceeded