Skip to Content

Leave cell blank in report painter

Feb 02, 2017 at 09:36 AM


avatar image
Former Member


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!



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

1 Answer

avatar image
Former Member 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.



10 |10000 characters needed characters left characters exceeded