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

gcaldis
Occasional Contributor

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

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

2 ACCEPTED SOLUTIONS

Accepted Solutions
Yash1
Frequent Contributor

Hi @gcaldis ,

 

You may use a formula like :

 

IF MONTH('End Period(Last Actual)') = 12 THEN FY + 1 ELSE FY + 10

 

Yash1_0-1579826611289.png

 

I have used FY + 10 else to display a blank, assuming there won't be more than 10 years in application. You can use some other else depending upon your specific requirement.

 

Thanks,

Yash

 

 

 

 

View solution in original post

Ingilavicus
Certified Master Anaplanner

Hi,

Or just simply use ELSE BLANK at the end to be sure the cells there is no undesired outcome.

Andris

View solution in original post

4 REPLIES 4
Yash1
Frequent Contributor

Hi @gcaldis ,

 

You may use a formula like :

 

IF MONTH('End Period(Last Actual)') = 12 THEN FY + 1 ELSE FY + 10

 

Yash1_0-1579826611289.png

 

I have used FY + 10 else to display a blank, assuming there won't be more than 10 years in application. You can use some other else depending upon your specific requirement.

 

Thanks,

Yash

 

 

 

 

Ingilavicus
Certified Master Anaplanner

Hi,

Or just simply use ELSE BLANK at the end to be sure the cells there is no undesired outcome.

Andris
gcaldis
Occasional Contributor

Thanks Andris, I will keep that in mind.

gcaldis
Occasional Contributor

Thanks Yash

This has solved my requirement.

Regards

George