How to get the balance from two columns

[tahreen371]

Hello All,

I have two columns: AMT and PAYMENT and now i need to get a BALANCE Column out of it.

I have 4 invoices for two different Document number and now as you see in the attachment if the total Amount of the 3 invoices is same as Payment done then Balance is Zero

And if payment is not matching with Amount coulumn then Balance should show the amount as in payment.

Please find the attachment 

regards and thanks 

[jyothish8807]

Hi Tahreen,

You can simply try:

sum(AMT)+sum(PAYMENT) in a straight chart. Rest fields as dimension.

[tahreen371]

Hi KC,

but there are few values which are negative in Amount column as well so two negatives will give an huge sum in balance which will be incorrect.

[jyothish8807 · Accepted solution]

May be this then,

fabs(Sum(AMT))-fabs(SUM(Payments))

[tahreen371]

Thanks that worked