IIf statement with proper syntax for And

[FryGirl]

I've searched for this solution, but just can't seem to get the right structure.

Expr1: Sum(IIf(([CMDB]![Fig1] In ("1123","1493","1290","0345")) And (([CMDB]![fig2] In ("AA","LQ","ZZ")),[CMDB]![QTR0],0))

I get the error, function containing the wrong number of arguments but can't seem to figure out what's off.

 

[Norie]

Think you are overloading on/misplacing the parentheses.

Try this.

Expr1: Sum( IIf([CMDB]![Fig1] In ("1123","1493","1290","0345") And [CMDB]![fig2] In ("AA","LQ","ZZ"),[CMDB]![QTR0],0) )

 

[FryGirl]

Hi Norie,

I have tried that syntax, but it flags on [CMDB]![fig2] asking for a Parameter to be entered

 

[Norie]

Have you checked the field names?

 

[FryGirl]

Thanks, that's it. I was referencing the wrong table.