Calculating Report totals.

[Meredith9053]

Quick one - for those of you who know what to do that is!

Calculating report totals for an Invoice.

General stuff. Got Page Header, Order id header and detail all working as
planned. Need to work out order id footer.

What I would like is Subtotal of the body of order - which I have done. Text
box control source =Sum[ExtendedPrice]
Then would like to:

Add Freight of 10% (say $10 - order total is $100) Want to see just $10 in
this box.
Add Subtotal (want to see $110)
Add GST (australian tax) 10% (showing again just the 10% value of the second
subtotal amount ie $11
Then Grand total of $121.

example of finished product:

Subtotal $100
Freight $10
Subtotal $110
GST $11
Grand Total $121.

sure it is way easy for most of you, but please help me.

also, if i may can i ask another question.

If, for example I have a list of clients and each of them have a set
percentage discount over a main list price of products. how do i have that
particular percentage, automatically apply within my invoice. ie, want to
select customer and when i fill out products purchased, it will automaticall
show the product not at the list price of say $100, but at the set discount
price of 10% off, being $90.

I would prefer if this was applied when customer selected, as i dont want to
have to select 10% each time i enter an item purchased.

Thanks so much.

Meredith

 

[John Spencer]

First question:

SubTotal = SUM(ExtendedPrice])
Freight = Round(Sum(ExtendedPrice) * .1,2)
SubTotal = SUM(ExtendedPrice]) + Round(Sum(ExtendedPrice) * .1,2)
or = Round(SUM(ExtendedPrice) * 1.1,2)
GST = Round(.1 * Round(SUM(ExtendedPrice]) * 1.1,2),2)
Grand Tot = SUM(ExtendedPrice]) + Round(Sum(ExtendedPrice) * .1,2) + Round(.1
* Round(SUM(ExtendedPrice]) * 1.1,2),2)

OR
GrandTot = Round(Round(SUM(ExtendedPrice) * 1.1,2)*1.1,2)

2nd question is a bit more complex.
Is the field type currency?
Do you want to round up, round down, or just round if the discounted price
ends up being partial penny (or whatever the minimum size currency is)?
Are you going to store the full price or the discounted price?

The formula for a discounted price is
(1 - [DiscountPercent]) * FullPrice
I suspect that you already know that.


John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County