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

How can we show exactly what user wants in an input template?
Hi community, Its been a while I have not asked anything. What I need is as below. I have a module with entity (filter) and CoA dimension (in rows) for user input in forecast months. That's working fine. But now I have to incorporate a cost centre item in the grid so that users will have an option to select a cost centre…
How to dedupe txn assignments on owners that appears in multiple assignment columns?
Hi all, I have a module, which is dimensioned by Txn, and within this module, I have a few columns where I can assign owners. Txn Assignment Module: Parent Account Name Oppy ID TXN Name SOL Terr SOL Terr 2 SOL Terr 3 BMO 111 1 Loner's Territory BMO 111 2 Loner's Territory BMO 112 3 Loner's Territory I want to create a…
Rolling forecast
Hi , I have a requirement for my stakeholder to have a medium term forecast (by month for the next 6 months) and a more detailed rolling 15-week sales forecast by day which will then feed into the wider Supply Chain planning processes over time. This needs to be updated by the Sales representants for consolidation by the…