What is wrong with my nested IIF THEN ELSE statement?!

Allison Jones

I typically do not have issues with calculations - I am sure that this is a really stupid mistake I am making - but what I am doing wrong with this nested IIF THEN statement?!

 

iif ([Data Type] = "Income Statement" 

THEN iif([Data Type]="Net Sales" 

THEN [Value] else        "" END))

 

 

ricki

I dont know much about iif or how it differs from if but i think the problem is your parenthesis. did you try the following?

 

iif ([Data Type] = "Income Statement" )



THEN iif([Data Type]="Net Sales" )



THEN ( [Value] else        "" END)