sum iif error

[Adrian Trella]

I Try to put in a control source from a report the expresion

=Sum(Iif([Id_Tip]=6,[Supr],0))

but doesn't work
I receive the message

The expression you entered contain a invalid syntax

Id_tip and Supr are numeric field in the record source of the report (query)

Any ideea? Seems to be a simple error

 

[JamesMcS]

Welcome to the forum!

Try

=sum(iif([Id_Tip]=6,nz([Supr],0),0))

 

[Adrian Trella]

Thanks for reply
I found the error. The correct expresion is =Sum(Iif([Id_Tip]=6;[Supr];0))

But I encountered another problem
The results are corect in the detail section of "summaries only" report but the totals over group are incorect in the group footer or group header even I use the same control source.

Any ideea what coud cause this ?