IF Statements, Nested IF statements
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Behavior Analysis
- Transformation
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You do not need the additional "IF" between each condition and "or". You can wrap parts of the statement in () to separate if needed.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey Jonathan,
Thanks for such an immediate response. Unfortunately I am still getting an error as shown in my attachment.  
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Jonathan-Sherman forgot to tag you to my response, my apologies.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Jonathan-Sherman Oh my God, it worked. I missed another IF. Thank you so much.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much, I really appreciate it and I see that now. This community is very nice and helpful, I genuinely appreciate it,