Forum Discussion

Boja's avatar
Boja
Advocate II
8 years ago
Solved

Switch F-on Problem

Hello,   Could somebody please have a look at the switch measure and tell me why it is not working? it should show upper arrow.   Key = SWITCH( TRUE(), [ver1 fb]<[ver2 fb], UNICHAR(9660), [ver1 f...
Need Help
  • Boja's avatar
    Boja
    8 years ago

    Strange, but the IF f-on works well in this case. Luckely, there is no need for more nested IFs :)

     

    Key2 = 
IF(
[ver1 fb]<[ver2 fb], UNICHAR(9660),
IF( [ver1 fb]>[ver2 fb], UNICHAR(9650),UNICHAR(9644))
)

Boja's avatar
Boja
Advocate II
8 years ago

Strange, but the IF f-on works well in this case. Luckely, there is no need for more nested IFs :)

 

Key2 = 
IF(
[ver1 fb]<[ver2 fb], UNICHAR(9660),
IF( [ver1 fb]>[ver2 fb], UNICHAR(9650),UNICHAR(9644))
)