Skip to Content
avatar image
Former Member

Leave cell blank in report painter


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!



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 22, 2017 at 03:56 AM

    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.



    Add comment
    10|10000 characters needed characters exceeded