Forum Discussion

Chanleakna123's avatar
Chanleakna123
Post Prodigy
8 years ago
Solved

Add Another Condition

  HI All ,  i set formula condition as per above. but i have another condition is , If Material Code of 7770 & 7769= Discontinue . How to set such condition contains in the status formula a...
Dashboards
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi Chanleakna123,

     

    You can add a outer IF() function: 

     

    Status= IF([Material Code]=7770 or [Material Code]=7769,"Discontinue",<your original measure>)

     

    Best Regards,
    Qiuyun Yu

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi Chanleakna123,

 

You can add a outer IF() function: 

 

Status= IF([Material Code]=7770 or [Material Code]=7769,"Discontinue",<your original measure>)

 

Best Regards,
Qiuyun Yu