Filter positive/negative Net Change in Account Schedule Line

In my Account Schedule, I have a totalling of a number of G/L Accounts on a line A. This amount should however only sum the positive Nett Changes of the accounts.
On a line B I have the same totalling of G/L Accounts, but on this line I only want to sum the negative Nett Changes on the accounts.
I haven’t found any function with which I can achieve this. Anyone else?

Hi Michiel

Columns can be setup to use Net Amount, Debit Amount or Credit Amount but these options are not available for rows in Account Schedules.



Hi Claus,

Yes, I know that I can set up the columns in this way. But I cannot summarize two separate columns! [:’(]

I’m afraid I have to think of some other solution…