Aggregate Function error when running query

[DrandonC]

Hello. I have the following formula in my query:

Rx Payments: IIf([tbl_RevCode_Classifications].[Total Charges]=0,0,Sum(([tbl_RevCode_Classifications].[Rx Charges]/[tbl_RevCode_Classifications].[Total Charges])*[tbl_RevCode_Classifications].[CashReceipts]))
On the Total Line I have "Expression"

When I run the query I get "your query does not include the specified expression as part of an aggregate function" on that above formula.

Google sites argue that I need "Group by". I tried that rather than Expression to no avail.

I've been at this all day and don't know what else to do. HELP.

Thank you.

 

[Joe4]

Welcome to the Board!

I think you may have structured it wrong. You typically see "SUM" on The "Totals" row of the query, not in the formula itself in Aggregate Queries.
Can you post a small sample of your data, along with an explanation of your expected results?

 

[Micron]

The Google notion that you need Group By likely doesn't apply to your calculated field - it may be that one or more fields used in that expression is also part of the SELECTed fields but it/they are not part of a Group By. Just a guess without seeing the entire sql. Even then it's not likely I'd know for sure as I usually have trouble getting what I want from a Totals query.