Very Simple Calculation

goldenvision

Registered User.
Local time
Today, 22:49
Joined
Oct 22, 2003
Messages
49
Having a bit of a brain melt here. (Well it is Friday !!)

I am trying to run the following calculation, but ot no avail.

=Sum(5-([Payment]))

And instead of getting the results of 5 minus the value in the payment field (which is £1, £2 or £4) I get £36.00

Any clues
 
=Sum(5-([Payment]))

And instead of getting the results of 5 minus the value in the payment field (which is £1, £2 or £4) I get £36.00

This should not return the results of 5 minus the value in the payment field, it should be returning the sum of (the results of 5 minus the value in the payment field).

Are you sure this is not what you are getting?

???
ken
 
=5 - Sum([Payment])
returns what you SAID you wanted.
 

Users who are viewing this thread

Back
Top Bottom