If THEN ELSE syntax

Options
denise_a_dewyer
denise_a_dewyer Member, ALL USERS, Community Pioneer Posts: 2 Master Anaplanner of the Year
in Planning & Modeling

Hello, I am having an issue with IF THEN ELSE forumla syntax. I have the following fuctioning forumla, in the context of converting weeks to months. IF Start Difference <= -23 AND Start Difference >= -28 AND End Difference >= 7 THEN ITEM(Week) ELSE BLANK I am trying to add a condition that says if the week start date is a hard date, then also return the ITEM(Week) date.  Neither of the forumlas below are  working.  Does anyone have a suggestion on how I should be adding the Period Start nested formula?  Thanks for any help!! IF Period Start = 1/1/2017 THEN "Week 5" ELSE IF Start Difference <= -23 AND Start Difference >= -28 AND End Difference >= 7 THEN ITEM(Week) ELSE BLANK IF Period Start = 1/1/2017 THEN ITEM(Week) ELSE IF Start Difference <= -23 AND Start Difference >= -28 AND End Difference >= 7 THEN ITEM(Week) ELSE BLANK

Tagged:

Comments

  • denise_a_dewyer
    denise_a_dewyer Member, ALL USERS, Community Pioneer Posts: 2 Master Anaplanner of the Year
    I figured it out, it was the date versus number format.  I converted the day and month to numbers instead of dates and it worked.


    IF MONTH(Period Start) = 1 AND MONTH(Week Start) = 1 AND DAY(Week Start) = 30 then 7 ELSE END(ITEM(Time)) - Week Start

Categories