Logical Functions-IF ELSE statement - Trying to apply condition where line item text contains "DEC"

Options
gcaldis
gcaldis Member, ALL USERS, GroupMember, Community Member Posts: 5 Occasional Contributor
in Planning & Modeling

Hi there

I wish to populate the line item "FY TEST" with the future financial year when any "Dec" month is selected in line item

"End Period (Last Actual)"   For example, return "FY20" in "FY TEST" when "Dec 19" is selected in "End Period (Last Actual)".

gcaldis_1-1579823544082.pnggcaldis_2-1579823581222.png

The formula I have tried to write for line item "FY TEST" is below but the syntax is not correct.

 

IF End Period (Last Actual) = Dec% THEN PARENT('End Period (Last Actual)') + 1 ELSE PARENT('End Period (Last Actual)')

 

Can someone please assist with providing the correct syntax for this formula?

 

Many thanks

George

Tagged:

Comments

  • gcaldis
    gcaldis Member, ALL USERS, GroupMember, Community Member Posts: 5 Occasional Contributor

    Thanks Yash

    This has solved my requirement.

    Regards

    George

  • gcaldis
    gcaldis Member, ALL USERS, GroupMember, Community Member Posts: 5 Occasional Contributor

    Thanks Andris, I will keep that in mind.

Categories