Forum Discussion

smather's avatar
smather
Helper III
5 years ago
Solved

M Code Percentage Thresholds

Hi   I created a custom column in the Query Editor:    if [Phase] = "Equipment" and [Margin] < 20 then "Below Threshold" else null   I've also used 0.20/0.19 and 19 to no avail, as it keeps hig...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, smather 

     

    You can try: if text.trim([Phase]) = "Equipment" and [Margin] < 20 then "Below Threshold" else null

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
5 years ago

smather , first of check the datatype and some values. Because ideally .2 or 20 one or the value should work

 

Also, check case and space issue with value Equipment in column Phase