getting sums in report

[rwahdan1978]

Hi

I have the below report that has payment field. the paymnet can vary between 100 and 500 and it is shown in the report above the first bound textbox below.



the first textbox bound should get the remainder of (500 - the number above taken from table). example if the number is 200 then it is 500-200 then the textbox value should be 300. and the bottom of the report (the second bound textbox), should have the total of the remainders of all records.

How to do that? I am trying to do that in a query but I am not sure how to do math in queries.

[June7]

Would that be the number of customers X 500 - sum of payment1 ?

First UNBOUND textbox: =500 - [Payment1]

Second UNBOUND textbox: =Count(*) * 500 - Sum([Payment1])

Will customer be unique in Detail section - each customer has only one record?

[rwahdan1978]

I tried this in the report footer

textbox1=([Text12].[Value]*500)
textbox2=Sum([Payment1])

so i am getting as an example

5300
3400

now how to get the difference of them in third textbox. I tried I am getting all 3 textboxs as erros.

[ano]

ofcourse each customers should have multiple records else the setup is useless
so count need only groups unless the report have done the sum already but then the field is useless

[June7]

Multiple customer records unless report filter results in one per customer.

Possibly need to base report on an aggregate query that summarizes customer payments.

Could provide db for analysis. Follow instructions at bottom of my post.

[ano]

1st ur code make no sense comparing ur text ; text say - code tell *
2nd if payment is summarized already why u need difference?
3rd nice u get errors and want help on all errors availble in report the error would make sense for us perhaps
seems u forget to upload ur database for analyze and understand ur problem

[Minty]

@Ano - I wish you would not use "text speak" in your answers.
A lot of posters here don't use English as their first language (I'm not sure if it's you native language), and a longer better constructed reply from you might make more sense to them.

[Micron]

Ditto. Have to wonder if it's an 'English is not the primary language' thing, or if it's a 'millennial who's too lazy to type full words and sentences'.
If it's about English then may I suggest anyone in that category type their post in Google translate and paste that. It will be better than what we're reading.