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

Formula that will calculate values in multiple rows with same id? 0
Totaling An Aggregate Expression On A Report 4
IF statement with 2 logicals 1
IIF in Crosstab Expression 0
complex count formulas using multiple criteria in different ranges 4
sum of calculated fields in header of report 1
Change values in report depending on certain criteria 2
Access Report Average Miles/Gallon in Group Footer and Report Footer? 9

Top