SBX - Search With Button

SBX - Forum Post Title

"if else if" like condition in data formula in Scribe

Microsoft Dynamics CRM Forum

Rawish Kumar asked a question on 13 Aug 2018 12:43 AM
My Badges

Question Status

Verified

Hi Experts, 

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 :

IF(AND(S1=0, S2=0,S3=0),"0","")

 

but how do it check other value from these fields? Like and IF , Else IF condition? 

your help is much appreciated.

Reply
Ravi Kashyap responded on 13 Aug 2018 1:09 AM
My Badges
Verified Answer

Hi Rawish,

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))

Reply
Rawish Kumar responded on 13 Aug 2018 1:20 AM
My Badges

Hi Ravi,

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.

Reply
Ravi Kashyap responded on 13 Aug 2018 1:23 AM
My Badges

Do confirm if it works.

Reply
Ravi Kashyap responded on 13 Aug 2018 1:09 AM
My Badges
Verified Answer

Hi Rawish,

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))

Reply

SBX - Two Col Forum

SBX - Migrated JS