9 Replies Latest reply: May 16, 2017 5:16 AM by Saran Wanjiru

# Question

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.

• ###### Re: Question

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

rangesum(Pledged,-Paid) as Balance,

• ###### Re: Question

Hi M W

They both are on different tables

• ###### Re: Question

Hi Saran,

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

Regards,

Andrey

• ###### Re: Question

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 .

• ###### Re: Question

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

• ###### Re: Question

Thats a typo its sheet.

• ###### Re: Question

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

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

• ###### Re: Question

thanks it worked

• ###### Re: Question

Use

RangeSum(

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

)

RangeSum function is used for calculations with NULL values.