Question

[#1]

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.

[m_woolf]

If Pledged budget and Paid budget are tin the same table:

rangesum(Pledged,-Paid) as Balance,

[#3]

Hi M W

They both are on different tables

[ahaahaaha]

Hi Saran,

Can there be a fragment of the original data in order not to guess?

Regards,

Andrey

[#5]

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 .

[Anonymous]

When you say shit do you mean sheet - or do you mean excel is rubbish ?

[#7]

Thats a typo its sheet.

[RonaldDoes · Accepted solution]

Is there any reason you could not use an expression like:

=Sum([Pledged amount]) - Sum([Paid amount])

[stantrolav]

Use

RangeSum(

     Sum([Pledged budget]), -Sum([Paid budget])

                  )

RangeSum function is used for calculations with NULL values.

[#10]

thanks it worked