Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

If function

Hi,    I have created this measure   Arrow R12 Rank = if([Rolling 12 Difference Rank]>0,"↑",if([Rolling 12 Difference Rank]=0,"-","↓"))   The rolling 12 difference is -1 but when I am putting ...
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

Anonymous Try:

Arrow R12 Rank = 
  VAR __RollingDiff = [Rolling 12 Difference Rank]
  VAR __Result = 
    SWITCH(TRUE(),
     [Rolling 12 Difference Rank] > 0,"↑",
     [Rolling 12 Difference Rank] < 0,"↓",
     "-"
    )
RETURN
  __Result