Very simple calculation in a report

[goldenvision]

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

 

[Norie]

Should it not be this:

=5 - Sum([Payment])

 

[SydneyGeek]

... or this?
=5-[Payment]

This is what you need if you are subtracting EACH payment value from 5. The Sum([Payment]) statement will add ALL values in the Payment field, before subtracting that from 5 -- adn you'll get the same result in every line

Denis