Skip to Content
avatar image
Former Member

Leave cell blank in report painter

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.

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.

    Regards,

    Kanishka

    Add comment
    10|10000 characters needed characters exceeded