Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Multiple if conditions

Hello I need help with multiple if conditions writing a conditional statement for the below logic   ≤9.0%= 10 pts >9% and 2 ppt <2022rate = 10 pts >9% and 1-1.99 ppt <2022 rate= 5pts   I trie...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

Anonymous Maybe:

color_annual = 
  SWITCH(TRUE(),
    'PCR_Summary_D/M/Q/Y'[RATE-%] <= .9 , "10pts",
    'PCR_Summary_D/M/Q/Y'[RATE-%] > .9 && 'PCR_Summary_D/M/Q/Y'[RATE-%YOY] >= 1.99), "10pts",
    'PCR_Summary_D/M/Q/Y'[RATE-%] > .9 && 'PCR_Summary_D/M/Q/Y'[RATE-%YOY] <= 1.99), "5pts",
    "0pts"
  )