Forum Discussion

SS_1122's avatar
SS_1122
Frequent Visitor
3 years ago
Solved

Nested IF and AND to create a custom column

Hey All, Thank you in advance to help me solve this problem. I am trying to create a custom column called "File check" with the help of the below data: So, the calculation I wrote for File C...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    SS_1122 , It should be like

     

    File Check = Switch (True() ,
    (Table [key] = 1 && Table[value] = 1 )|| (Table[key] =2 && Table[value] = 1), "File check Successful",
    (Table [key] = 1 && Table[value] <> 1) || (Table[key] =2 && Table[value] = 1 ), "File check Not Successful",
    (Table [key] = 1 && Table[value] = 1) || (Table[key] =2 && Table[value] <> 1) , "File check Not Successful",
    (Table [key] = 1 && Table[value] <> 1) || (Table[key] =2 && Table[value] <>1) , "File check Not Successful")

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

SS_1122 , It should be like

 

File Check = Switch (True() ,
(Table [key] = 1 && Table[value] = 1 )|| (Table[key] =2 && Table[value] = 1), "File check Successful",
(Table [key] = 1 && Table[value] <> 1) || (Table[key] =2 && Table[value] = 1 ), "File check Not Successful",
(Table [key] = 1 && Table[value] = 1) || (Table[key] =2 && Table[value] <> 1) , "File check Not Successful",
(Table [key] = 1 && Table[value] <> 1) || (Table[key] =2 && Table[value] <>1) , "File check Not Successful")