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)".

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

Accepted answers

Yash1

Hi @gcaldis ,

You may use a formula like :

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

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

Hi,

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

Andris

All comments

Yash1

Hi @gcaldis ,

You may use a formula like :

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

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

Hi,

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

Andris

gcaldis

Thanks Yash

This has solved my requirement.

Regards

George

gcaldis

Thanks Andris, I will keep that in mind.

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…