MIM- IIF function expression

Question

Hi All,

IIF(Eq(GeoID,"AE"),"+971",IIF(Eq(GeoID,"AU"),"+61",IIF(Eq(GeoID,"CA"),"+1",IIF(Eq(GeoID,"CN"),"+86",IIF(Eq(GeoID,"DE"),"+49",IIF(Eq(GeoID,"DK"),"+45",IIF(Eq(GeoID,"FI"),"+358",IIF(Eq(GeoID,"FR"),"+33",IIF(Eq(GeoID,"GB"),"+44",IIF(Eq(GeoID,"GR"),"+49",IIF(Eq(GeoID,"IE"),"+353",IIF(Eq(GeoID,"ML"),"+223",IIF(Eq(GeoID,"NL"),"+31",IIF(Eq(GeoID,"NO"),"+47",IIF(Eq(GeoID,"PL"),"+48",IIF(Eq(GeoID,"SE"),"+46",IIF(Eq(GeoID,"SG"),"+65",IIF(Eq(GeoID,"SW"),"+46",IIF(Eq(GeoID,"UK"),"+44",IIF(Eq(GeoID,"US"),"+1","+91"))))))))))))))))))))

tried to add in the synchronization rule but getting the following error

" is not a valid attribute.

Need your help!

Thanks,
Shashidhar Joliholi

Answer 1

Seems there is some quirks in the parser that, if you need to use "+" in your string literals, you have to name the parameters for IIF() .