work with calculations

[Guest]

thanks for all the help i have had so far

i have a report with two fields i need to do calculations on.

Payments
AmountRecieved

i have found it easy to get a total of each
=Sum(Payments) etc.

how do i get access to calculate the difference between the totals

e.g the sum of Pyments - the sum of amountrecieved = amount still owing


thanks for any help

Phil

 

[Guest]

Try this

=Sum([Payments] - [AmountRecieved])

 

[Guest]

thanks for the reply

i tried this before i posted here. it gives me the answer 250 and i cannot
see where it gets this figure from

Try this

=Sum([Payments] - [AmountRecieved])
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

thanks for all the help i have had so far

i have a report with two fields i need to do calculations on.

Payments
AmountRecieved

i have found it easy to get a total of each
=Sum(Payments) etc.

how do i get access to calculate the difference between the totals

e.g the sum of Pyments - the sum of amountrecieved = amount still owing


thanks for any help

Phil

 

[Guest]

What do you get wahen you sum each field seperatly?
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

thanks for the reply

i tried this before i posted here. it gives me the answer 250 and i cannot
see where it gets this figure from

Try this

=Sum([Payments] - [AmountRecieved])
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

thanks for all the help i have had so far

i have a report with two fields i need to do calculations on.

Payments
AmountRecieved

i have found it easy to get a total of each
=Sum(Payments) etc.

how do i get access to calculate the difference between the totals

e.g the sum of Pyments - the sum of amountrecieved = amount still owing


thanks for any help

Phil

 

[Guest]

i get the correct figure if i sum them individually

£2950 and £1350 respectively obviously the difference is £1600 which is why
i cannot see where £250 comes from

Phil

What do you get wahen you sum each field seperatly?
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

thanks for the reply

i tried this before i posted here. it gives me the answer 250 and i cannot
see where it gets this figure from

Try this

=Sum([Payments] - [AmountRecieved])
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck



:

thanks for all the help i have had so far

i have a report with two fields i need to do calculations on.

Payments
AmountRecieved

i have found it easy to get a total of each
=Sum(Payments) etc.

how do i get access to calculate the difference between the totals

e.g the sum of Pyments - the sum of amountrecieved = amount still owing


thanks for any help

Phil

 

[Guest]

I can't see a reason why that should happen, another option will be
=[Name Of the Payments sum Field] - [Name Of the AmountRecieved sum Field]
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

i get the correct figure if i sum them individually

£2950 and £1350 respectively obviously the difference is £1600 which is why
i cannot see where £250 comes from

Phil

What do you get wahen you sum each field seperatly?
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

thanks for the reply

i tried this before i posted here. it gives me the answer 250 and i cannot
see where it gets this figure from

:

Try this

=Sum([Payments] - [AmountRecieved])
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck



:

thanks for all the help i have had so far

i have a report with two fields i need to do calculations on.

Payments
AmountRecieved

i have found it easy to get a total of each
=Sum(Payments) etc.

how do i get access to calculate the difference between the totals

e.g the sum of Pyments - the sum of amountrecieved = amount still owing


thanks for any help

Phil

 

[John Spencer]

For some reasaon there seems to be a double count of the AmountReceived
(1350 * 2 = 2700).
2950 - 2700 = 250

I would try
=Sum([Payments]) - Sum([AmountRecieved])

i get the correct figure if i sum them individually

£2950 and £1350 respectively obviously the difference is £1600 which is
why
i cannot see where £250 comes from

Phil

What do you get wahen you sum each field seperatly?
--
If I answered your question, please mark it as an answer. That way, it
will
stay saved for a longer time, so other can benifit from it.

Good luck

thanks for the reply

i tried this before i posted here. it gives me the answer 250 and i
cannot
see where it gets this figure from

:

Try this

=Sum([Payments] - [AmountRecieved])
--
If I answered your question, please mark it as an answer. That way,
it will
stay saved for a longer time, so other can benifit from it.

Good luck



:

thanks for all the help i have had so far

i have a report with two fields i need to do calculations on.

Payments
AmountRecieved

i have found it easy to get a total of each
=Sum(Payments) etc.

how do i get access to calculate the difference between the totals

e.g the sum of Pyments - the sum of amountrecieved = amount still
owing


thanks for any help

Phil

 

[Guest]

i tiried that with the

=Sum([Regfee]-[Payfee])

and i get a parameter query come up

i tthink i might give this up as a lost cause

I can't see a reason why that should happen, another option will be
=[Name Of the Payments sum Field] - [Name Of the AmountRecieved sum Field]
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

i get the correct figure if i sum them individually

£2950 and £1350 respectively obviously the difference is £1600 which is why
i cannot see where £250 comes from

Phil

What do you get wahen you sum each field seperatly?
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck



:

thanks for the reply

i tried this before i posted here. it gives me the answer 250 and i cannot
see where it gets this figure from

:

Try this

=Sum([Payments] - [AmountRecieved])
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck



:

thanks for all the help i have had so far

i have a report with two fields i need to do calculations on.

Payments
AmountRecieved

i have found it easy to get a total of each
=Sum(Payments) etc.

how do i get access to calculate the difference between the totals

e.g the sum of Pyments - the sum of amountrecieved = amount still owing


thanks for any help

Phil

 

[Guest]

There is no need for the sum, just subtract the total Payments field with
the total AmountRecieved field that are on the footer, drop the sum, this is
why you get an error, the sum is already done in the other two fields.

=[Name Of the Payments sum Field] - [Name Of the AmountRecieved sum Field]
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

i tiried that with the

=Sum([Regfee]-[Payfee])

and i get a parameter query come up

i tthink i might give this up as a lost cause

I can't see a reason why that should happen, another option will be
=[Name Of the Payments sum Field] - [Name Of the AmountRecieved sum Field]
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

i get the correct figure if i sum them individually

£2950 and £1350 respectively obviously the difference is £1600 which is why
i cannot see where £250 comes from

Phil

:

What do you get wahen you sum each field seperatly?
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck



:

thanks for the reply

i tried this before i posted here. it gives me the answer 250 and i cannot
see where it gets this figure from

:

Try this

=Sum([Payments] - [AmountRecieved])
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck



:

thanks for all the help i have had so far

i have a report with two fields i need to do calculations on.

Payments
AmountRecieved

i have found it easy to get a total of each
=Sum(Payments) etc.

how do i get access to calculate the difference between the totals

e.g the sum of Pyments - the sum of amountrecieved = amount still owing


thanks for any help

Phil

 

[Guest]

Brilliant!!!

that has given me the correct total.

thanks

Phil

For some reasaon there seems to be a double count of the AmountReceived
(1350 * 2 = 2700).
2950 - 2700 = 250

I would try
=Sum([Payments]) - Sum([AmountRecieved])

i get the correct figure if i sum them individually

£2950 and £1350 respectively obviously the difference is £1600 which is
why
i cannot see where £250 comes from

Phil

What do you get wahen you sum each field seperatly?
--
If I answered your question, please mark it as an answer. That way, it
will
stay saved for a longer time, so other can benifit from it.

Good luck



:

thanks for the reply

i tried this before i posted here. it gives me the answer 250 and i
cannot
see where it gets this figure from

:

Try this

=Sum([Payments] - [AmountRecieved])
--
If I answered your question, please mark it as an answer. That way,
it will
stay saved for a longer time, so other can benifit from it.

Good luck



:

thanks for all the help i have had so far

i have a report with two fields i need to do calculations on.

Payments
AmountRecieved

i have found it easy to get a total of each
=Sum(Payments) etc.

how do i get access to calculate the difference between the totals

e.g the sum of Pyments - the sum of amountrecieved = amount still
owing


thanks for any help

Phil