Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.

1 Solution

Accepted Solutions
RonaldDoes
Partner - Creator III
Partner - Creator III

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

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

View solution in original post

9 Replies
m_woolf
Master II
Master II

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

rangesum(Pledged,-Paid) as Balance,

Not applicable
Author

Hi M W

They both are on different tables

ahaahaaha
Partner - Master
Partner - Master

Hi Saran,

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

Regards,

Andrey

Not applicable
Author

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
Not applicable
Author

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

Not applicable
Author

Thats a typo its sheet.

RonaldDoes
Partner - Creator III
Partner - Creator III

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

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

stantrolav
Partner - Creator II
Partner - Creator II

Use

RangeSum(

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

                  )

RangeSum function is used for calculations with NULL values.

Not applicable
Author

thanks it worked