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 fb]>[ver2 fb], UNICHAR(9650),
UNICHAR(9644)
)

  

 

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))
)

4 Replies

  • 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))
)

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    OK, that's the second one today that I can't recreate. I tried by entering in your data and then adding a calculated column. I used a calculated column because there is no aggregation that would indicate that it is a measure. I get up arrows. I'm on the March 2018 edition.

    • Boja's avatar
      Boja
      Advocate II
      8 years ago

      Hi Greg,

       

      Actually there is aggreagation. Both var1 fb and var2 fb are counts of responses by different criteria. 

      I am also working on the March edition, but will try to reinstall anyway.

       

      do you maybe have another suggestion? thank you for support though :)

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        8 years ago

        OK, so "var1 fb" and "var2 fb" are measures then. I'll try to recreate it with measures.