What is wrong with this formula?

W

WildlyHarry

=sum(IIf([desc]="rtn" And [Data]=0.01,Sum(IIf([desc]="hld" And
[Data]<>0.01,[Data],0)),0))
I am using the above formula to replace data. .01 is a place holder that
lets me know I need to replace it. When I try to preview my report I get the
following error.
"Cannot have aggregate function in expression Sum(IIf([desc]="rtn" And
[Data]=0.01,Sum(IIf([desc]="hld" And [Data]<>0.01,[Data],0)),0))."

Any thoughts on how to get this to work? Thanks in advance for your response.
 
J

Jeff C

Look at the IIF syntax:

IIF(This, Then, Else)

Get your iif statement to work and then add your Sum function.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Aggregate Function Error 0
Totaling An Aggregate Expression On A Report 4
report "this expression is typed Incorrectly...", query works 1
complex count formulas using multiple criteria in different ranges 4
sum of calculated fields in header of report 1
Want Sum in Report Header of calculated field in Report Detail ? 1
SLOW formula 2
How do I handle numeric data with < values in Access? 10

Top