Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

IF statement with several conditions

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi all, thank you for your kind replies!! I managed to get the results using the formula below after several attempts :) 

     

    Formula:

     

     

vcastello's avatar
vcastello
Icon for Resolver III rankResolver III
8 years ago

Hi Anonymous

You can try SWITCH.

 

Should something like this work?


SWITCH(
    TRUE (),
    VALUES(Arrears[TCMRScoring_ArrearsAcct %]) < 3, 5,
    VALUES(Arrears[TCMRScoring_ArrearsAcct %]) < 4, 4,

    VALUES(Arrears[TCMRScoring_ArrearsAcct %]) < 5, 3,
    VALUES(Arrears[TCMRScoring_ArrearsAcct %]) < 6, 2,
     1
)

 

Anyway, your Arrears[TCMRScoring_ArrearsAcct %] should be wrapped. With VALUES, SUM, or other function


Hope That Helps

Vicente