|
| Re: Total and Balance at the end of the table |
| Iniciado por guest, 03,jun. 2017 08:32 - 1 respuesta |
| |
| | | |
|
| |
| Publicado el 03,junio 2017 - 08:32 |
Hello,
I got five columns
Date, Number, Particulars, Debit Amount, Credit Amount in a table. I want to have total for Debit Amount and Credit Amount and also balance in the next line. The Automatic Calculation (Sum) is not enough, as there's no way to show the balance (deducting Credit Amount from Debit Amount) in the next row. So I need to go with breaks.
Here the problem is what to set for break, as this to be shown at the end of the table. No field qualifies for break here. Any idea ?
Happiness Always
BKR Sivaprakash |
| |
| |
| | | |
|
| | |
| |
| Publicado el 03,junio 2017 - 12:46 |
Hi
I guess that you can add an invisible numerical column that you don't set (so it's zero all the way) and set your break on it
At the end of the table, you should get the break for the value 0, and you can put your balance in it
Or you just set the balance in a separate field under the table.
Best regards |
| |
| |
| | | |
|
| | | | |
| | |
|