Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Tahreen,
You can simply try:
sum(AMT)+sum(PAYMENT) in a straight chart. Rest fields as dimension.
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.
May be this then,
fabs(Sum(AMT))-fabs(SUM(Payments))
Thanks that worked