Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Custom Column Query

Hello,   I have a column which has values of = "0", "1" and Empty.   How do I create a custom column which gives me the following information.   IF  0 = Fail 1 = Pass Empty = Pass   I've b...
General Comment
Need Help
Show and Tell
Tutorial Requests
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi Anonymous ,

     

    M code is completely case-sensitive, so using 'IF' instead of 'if' will cause the calculation to fail. Similarly, referencing '1' instead of ' "1" ' if the value is in a text field will also fail.

    Also, your condition is picking out the 1 = pass criteria first. It's simpler to pick out the 0 = Fail first, then just apply pass to 1 and null as per your requirement.

     

    Try these calculations to see what works for you:

    // [Attend Pass] = numeric
if [Attend Pass] = 0 then "Fail" else "Pass"

// [Attend Pass] = text
if [Attend Pass] = "0" then "Fail" else "Pass"

     

    Pete

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
4 years ago

Hi Anonymous ,

 

M code is completely case-sensitive, so using 'IF' instead of 'if' will cause the calculation to fail. Similarly, referencing '1' instead of ' "1" ' if the value is in a text field will also fail.

Also, your condition is picking out the 1 = pass criteria first. It's simpler to pick out the 0 = Fail first, then just apply pass to 1 and null as per your requirement.

 

Try these calculations to see what works for you:

// [Attend Pass] = numeric
if [Attend Pass] = 0 then "Fail" else "Pass"

// [Attend Pass] = text
if [Attend Pass] = "0" then "Fail" else "Pass"

 

Pete