Forum Discussion

actzikas's avatar
actzikas
Frequent Visitor
6 years ago
Solved

IF ELSE Statement for Column

I am trying to create an If Statement to create/group a column in the following order.  If Probability < 50 then it is "Early"  If Probability >= 50 or < 75 then it is "Warm"  If Probability is ...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi actzikas 

    i dont think you need the last statement 

    IF(Opportunity[Probability] >= 75, "Late"

    because you have already described any of possible values.

    so, you could leave just

    Piepline Probability Stage = IF(Opportunity[Probability] < 50, "Early", IF(Opportunity[Probability] >= 50 || Opportunity[Probability] < 75, "Warm", "Late"))
VasTg's avatar
VasTg
Memorable Member
6 years ago

actzikas 

 

It is easier to create a calculated Column in Edit Queries/Transform Data.

 

 

If this helps, accept it as a solution.

Kudos are good too.

actzikas's avatar
actzikas
Frequent Visitor
6 years ago

Thank you for the conditional column advise, but I wanted to do this via an IF Statement so I marked the other one as the solution but as you stated both work!