I hope we have many scribe experts here in the community.
I am very new to Scribe - i am in a situation where i have to check three field values which can either be 0 or 1 or null. if all source fields are "0" i have to set target to "0", if all are "1" i have to set target to "1". otherwise if any field is null or not matching is criteria it has to be null.
I am able to check something like below :
but how do it check other value from these fields? Like and IF , Else IF condition?
your help is much appreciated.
I have tried this but may be this would work-
IF(AND(S1=0, S2=0,S3=0),"0",IF(AND(S1=1, S2=1,S3=1),"1",null))
Wow. I have entered this formula and scribe didn't complain about anything. Looks like its going to work :)
Marked as verified for now. Thanks for your help.
Do confirm if it works.
Business Applications communities