Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

If statement using or

Hi,   Have the below measure. It returns the number 6 if conditions are met. This is what i want.   ScoreM = VAR conscore = IF([8 Wks Con] = 7 && [8 Wk Avg] > 20,6) Return conscore   Howev...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Arrh yes. I normally use ';' but then you should just adjust the measure:

     

    scoreM = 
IF([8 Wks Con] = 7 && [8 Wks Avg] > 20, 6, IF([8 Wks Con] = 6 && [8 Wks Avg] < 20, 1, BLANK()))
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Arrh yes. I normally use ';' but then you should just adjust the measure:

 

scoreM = 
IF([8 Wks Con] = 7 && [8 Wks Avg] > 20, 6, IF([8 Wks Con] = 6 && [8 Wks Avg] < 20, 1, BLANK()))
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Yeah, that works a treat. Thanks a million.