Forum Discussion
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 Check is :
File Check = if (Table [key] = 1 && Table[value] = 1 && Table[key] =2 && Table[value] = 1, "File check Successful", if ( Table [key] = 1 && Table[value] <> 1 && Table[key] =2 && Table[value] = 1 , "File check Not Successful", if(Table [key] = 1 && Table[value] = 1 && Table[key] =2 && Table[value] <> 1 , "File check Not Successful", if (Table [key] = 1 && Table[value] <> 1 && Table[key] =2 && Table[value] <>1 , "File check Not Successful"))))
But this shows nothing in the column and I relaized that I cannot have multiple "&&" , but I am not sure how to write this with switch statement.
Thanks
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")
1 Reply
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")