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

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.