Forum Discussion

rafterse's avatar
rafterse
Helper I
2 years ago
Solved

boolean on other boolean

Help please  this is the data  User_ Induction complete_ Test name_ Test result_  Bill  True A Pass Bill  True B Pass Bill  True C Fail Sue False A Pass Sue Fa...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi rafterse 

     

    Thanks for the reply from sanalytics .

     

    If your problem has not been resolved, try the following:

     

    Create a calculated column as follow

    Action =
IF (
    [Induction complete_] = "False",
    "Complete Induction",
    IF (
        [Test result_ ] = "Pass",
        "Test " & [Test name_] & " Pass",
        "Retake test " & [Test name_]
    )
)

     

    Create a calculated table as follow

    Table 2 = SELECTCOLUMNS('Table', "User_", [User_], "Action", [Action])

     

    Result:

     

    Best Regards,
    Yulia Xu

     

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi rafterse 

 

Thanks for the reply from sanalytics .

 

If your problem has not been resolved, try the following:

 

Create a calculated column as follow

Action =
IF (
    [Induction complete_] = "False",
    "Complete Induction",
    IF (
        [Test result_ ] = "Pass",
        "Test " & [Test name_] & " Pass",
        "Retake test " & [Test name_]
    )
)

 

Create a calculated table as follow

Table 2 = SELECTCOLUMNS('Table', "User_", [User_], "Action", [Action])

 

Result:

 

Best Regards,
Yulia Xu

 

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