Nested IIf issue

[heathb]

Ladies and gents,

having an issue with the nested IIf only returning on one leg.

Data: IIf([Contract Size Table]![Location]<>"EUROPE","NO",IIf([Entities]![European Entity]="NO","NO","YES"))

Output example attached

The above works fine when set individually. I have checked around and obviously it is going to be a simple fix, but I cannot see it..

As usual, all help greatly rec'd

 

[heathb]

solved, not sure why though

Data: IIf([Contract Size Table]![Location]="EUROPE","YES",IIf([Entities]![European Entity]="NO","NO","YES"))

 

[plog]

My guess is that some of those values that look like "EUROPE" are not actually "EUROPE" values. To wit:

"EUROPE " <> "EUROPE"

"EUROPE " used in the first code would return "NO"
"EUROPE " used in the second one woudl return "YES"


Of course if you have any "NO " values, the second code will return "YES".

 

[heathb]

My thought, but checked that with another IIf and that works fine

EU venue: IIf([Contract Size Table]![Location]="EUROPE","Y","N")

thanks anyway