Re: Percent on sum total

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thank you since your first suggestion in placing the expression in query
worked as well as creating a separate field for the percent. How would you
create the expression if we need to subtract 6 percent from the country china
and 3 percent from country brazil? Can this be done on the same report?

"Al Campagna" wrote:

acss,
Perhaps I misunderstood...
When you wrote...
subtract the subtotal by 3 percent?
Did you mean that whatever the sum of InvAmt is, for a Country, subtract
3% from that value.
If so, then this formula would do that...

=Sum(InvAmt) * .97

200 * .97 = 194 (Brazil)

800 * .97 = 776 (china)
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."


"acss" <joekru98@xxxxxxxxxxx> wrote in message
news:DC739C3B-2447-4CF6-90B0-43E435FC586A@xxxxxxxxxxxxxxxx
I have the calculation on the report and it only works on individual
records
per account. So if there is more than one record the calculation is
incorrect. Could this be a field in query not allowing for the calculation
to
work on a group?

"Al Campagna" wrote:

acss,
Add a calculated field to your query.
3Pct : InvAmt * .03
Add [3Pct] to your report to the right of your InvAmt
(can be hidden)
InvAmt 3Pct
brazil 25001 $100 3.00
25001 $100 3.00
200 =[Sum(InvAmt) - Sum(3Pct)] = 6.00
china 25002 $400 12.00
25002 $400 12.00
$800 =[Sum(InvAmt) - Sum(3Pct)] = 24.00

This calculation will work in any group or report footer.

--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your
life."




"acss" <joekru98@xxxxxxxxxxx> wrote in message
news:4A6E1A65-6ECE-4965-81A5-B3DD4535BE7B@xxxxxxxxxxxxxxxx
I have a country report which group two accounts and provides a subtotal
for
each account per country. How do i create another field that would
subtract
the subtotal by 3 percent? For example:

brazil 25001 $100
25001 $100
[SumOfInvAmt $200] subtract ths amt by 3%
china 25002 $400
25002 $400
[ SumOfInvAmt $800] subtract this amt by 3%






.

Relevant Pages

  • Re: String Used in Report Displays as Garbage
    ... Is there anything else in the database that has the name ProductCode? ... All the text in the calculated fields in my query are left aligned. ... I tried creating a new report with only the calculated field printed. ... You say the calculation looks fine in the query. ...
    (microsoft.public.access.reports)
  • Re: String Used in Report Displays as Garbage
    ... All the text in the calculated fields in my query are left aligned. ... I tried creating a new report with only the calculated field printed. ... You say the calculation looks fine in the query. ...
    (microsoft.public.access.reports)
  • Re: String Used in Report Displays as Garbage
    ... All the text in the calculated fields in my query are left aligned. ... I tried creating a new report with only the calculated field printed. ... When I simply open the query directly I see the field values exactly as I ... You say the calculation looks fine in the query. ...
    (microsoft.public.access.reports)
  • Re: Can I add a summary in the report footer to do this...?
    ... The report's source is the Audit Details Query. ... There is another text box with a similar calculation, ... As the report runs through each BU it does the calcs, sums them up in the BU ... >>> Create a totals query similar to your report's record source. ...
    (microsoft.public.access.reports)
  • Re: Percent on sum total
    ... The problem is that the report will be run from data that already exists ... formula to some how filter one country from the other on the report. ... then subtract that value from InvAmt.) ... Now you're beginning to see why doing a Rate calculation for each ...
    (microsoft.public.access.reports)