Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a data set that has Pledged budget and Paid budget , so i want to get the difference between the two as available balance.
what function do i use for the subtraction fields.
Thanks.
Is there any reason you could not use an expression like:
=Sum([Pledged amount]) - Sum([Paid amount])
If Pledged budget and Paid budget are tin the same table:
rangesum(Pledged,-Paid) as Balance,
Hi M W
They both are on different tables
Hi Saran,
Can there be a fragment of the original data in order not to guess?
Regards,
Andrey
the data is on 2 excel sheets one .in an excel shit we have a column containing payment in usd, on the other excel shit we have pledges in usd. now i need to subtract amount pledged from amount paid so that i can know the amount the donor has not paid that's the balance @Andrey Khoronenko .
When you say shit do you mean sheet - or do you mean excel is rubbish ?
Thats a typo its sheet.
Is there any reason you could not use an expression like:
=Sum([Pledged amount]) - Sum([Paid amount])
Use
RangeSum(
Sum([Pledged budget]), -Sum([Paid budget])
)
RangeSum function is used for calculations with NULL values.
thanks it worked