Sum IIf unable to get required result

[steve2jh]

i have a report with fields "Order Status" & "Cost". I have placed a txt box
in the report header & wish to display in this the sum of "Cost" where "Order
Status" = "approved". I have tried the following with no success
SUM(IIF([Order Status].Value="approved",[Cost].Value,[Cost].Value*0)

 

[Ofer Cohen]

Drop the value

Try:
SUM(IIF([Order Status]="approved",[Cost],0)

 

[Ofer Cohen]

Sorry, but also add equal sign before it, and Nz to replace Null with zero
incase cose is null

=SUM(IIF([Order Status]="approved",Nz([Cost],0),0)

--
Good Luck
BS"D

Drop the value

Try:
SUM(IIF([Order Status]="approved",[Cost],0)

--
Good Luck
BS"D

i have a report with fields "Order Status" & "Cost". I have placed a txt box
in the report header & wish to display in this the sum of "Cost" where "Order
Status" = "approved". I have tried the following with no success
SUM(IIF([Order Status].Value="approved",[Cost].Value,[Cost].Value*0)

 

[Duane Hookom]

Typo fix to add final ).

SUM(IIF([Order Status]="approved",[Cost],0))

I think you can also use:
SUM(Abs([Order Status]="approved") *[Cost])

--
Duane Hookom
Microsoft Access MVP

Drop the value

Try:
SUM(IIF([Order Status]="approved",[Cost],0)

--
Good Luck
BS"D

i have a report with fields "Order Status" & "Cost". I have placed a txt box
in the report header & wish to display in this the sum of "Cost" where "Order
Status" = "approved". I have tried the following with no success
SUM(IIF([Order Status].Value="approved",[Cost].Value,[Cost].Value*0)

 

[Ofer Cohen]

Thanks Duane

Typo fix to add final ).

SUM(IIF([Order Status]="approved",[Cost],0))

I think you can also use:
SUM(Abs([Order Status]="approved") *[Cost])

--
Duane Hookom
Microsoft Access MVP

Drop the value

Try:
SUM(IIF([Order Status]="approved",[Cost],0)

--
Good Luck
BS"D

i have a report with fields "Order Status" & "Cost". I have placed a txt box
in the report header & wish to display in this the sum of "Cost" where "Order
Status" = "approved". I have tried the following with no success
SUM(IIF([Order Status].Value="approved",[Cost].Value,[Cost].Value*0)

 

[steve2jh]

that did the trick thanks for all your help