Grand Total %

[Mike Hughes]

Please see attachment.

In the report footer I have the grand totals for all columns in the report.

Example:

Open cases 100
EST TYPE O 20 20/100 = 20%

Could somone help with this?

Thanks

 

[Rich]

It's simply =Sum([Est Type 0])/[Sum([OpenCases]) since you already have the textboxes with those calculations on the report it's simply a matter of identifying them I.e. add another unbound textbox on the report and set its control source to =[Textbox1]/[Textbox3] substitute the textbox names with the actual corresponding names on your Report

 

[Mike Hughes]

I still can't make this work. Please see my attachment which might help explain what I'm trying to do. If possible please go into details of what I should be putting where.

Thanks Mike

 

[DCrake]

Can you post a snippet of your app to look at.

 

[Mike Hughes]

Here is the DB

Thanks Mike

 

[DCrake]

In order to calulate a % you need at least 2 elements

the value that = 100%
the value that = a portion of the total

to get the % = total/100 * portion

Which field is the 100% total

 

[Mike Hughes]

If I understand what you're asking.

The 100 would be CURRENT OWED
And the Total would be CURRENT PAID

 

[DCrake]

You do not need the Sum in the group footer

Simply =[ARREARS PAID]/[ARREARS OWED]

set for as percentage
2 dec places

 

[Mike Hughes]

When I use the code you have here I get a percent of 0.51%

If I manualy figure the percent of
$2,679,692.02 / $503,862,608.08

I get 0.005318299

Why the difference?

 

[Mike Hughes]

In the report footer I have a sum of all the records in the columns, ARREARS PAID and AREARS OWED.

In a new text box in the report footer I thought using a control source of


=Sum([ARREARS PAID])/=Sum([ARREARS OWD]) would tell me what the % of PAID to OWED.

Like ARREARS PAID is $100 and ARREARS OWED is $200. The percent would be 50%

I'm getting the error:"The expression you entered contains an invalid syntax. You may have entered a comma with a preceding value or identifier"

Using what #8 says, "=[ARREARS PAID]/[ARREARS OWED]" , gives me a result of
0.005118629178486.

When I manually do the % of ARREARS PAID of $2679692.02 / ARREARS OWED of $503862608.08 it gives me 0.0053182990303867439942458688668168

The numbers are not the same. Doing it manually it gives me a higher %

What am I doing wrong?

 

[vbaInet]

=Sum([ARREARS PAID])/=Sum([ARREARS OWD]) would tell me what the % of PAID to OWED.

You only need one equal to sign (=) at the beginning.

 

[Mike Hughes]

Well all I can say is that it was a long trip. Your last code worked. Thanks so much!
Mike

 

[vbaInet]

Yup, the same syntax as what DCrake advised.

Glad to know it's resolved.