IF Statements, Nested IF statements

Hey Guys,

I think there is a problem with my IF statement in the example provided. What I want to do in the example provided is this:

The formula for CCD_Sent_In_Time should do this, If [Portal Status] is Registered or Registration Rejected Then the formula of IF [ReceivedDate] >= [ServiceDate] AND [ReceivedDate] <= [TW_Deadline] THEN 1 ELSE 0 ENDIF is put into place for CCD_Sent_In_Time but if the [Portal Status] is Info Provided then CCD_Sent_In_Time is 1 but if [Portal Staus] is Info Not Provided then CCD_Sent_In_Time is 0.

Thank you so much for your help in advance.

My current If Statement Example.PNG

Workflow

Transformation

Behavior Analysis

Accepted answers

Jonathan-Sherman

Hi @apoorvsingh,

The issue is your "IF" statements, you don't need all of them. You can remove the ones i've highlighted in yellow below:

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

All comments

echuong1

You do not need the additional "IF" between each condition and "or". You can wrap parts of the statement in () to separate if needed.

Jonathan-Sherman

Hi @apoorvsingh,

The issue is your "IF" statements, you don't need all of them. You can remove the ones i've highlighted in yellow below:

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

MichalM

@apoorvsingh

When you remove the IFs I highlighted you should be good

apoorvsingh

Hey Jonathan,

Thanks for such an immediate response. Unfortunately I am still getting an error as shown in my attachment.

Still getting Malformed IF statement.PNG

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703