How to convert Month to year (Ex: Apr 22-Mar 23 to FY 22as year)

Hi Everyone,

Is there any method that we can convert month to year, as i have scenario like timescale was APR 22 to Mar 23 as text formatted line item and we need to get a time period format as year and value would be as FY 22.

Any Advice.

Thanks

Accepted answers

Maheshkumar08

Hi Misbah,

Thanks, I have done that and earlier my mistake was i missed the Parent formula and now, Its cleared.

All comments

Misbah

@Maheshkumar08

Text has to be split into two time periods and then work off of that. In your case if it is FY 22 based off of Apr 22 then then I would say do this create three line items

LEFT(Text Formatted line item, 6), Format should be Text
FINDITEM(TIME, Line item 1) - Format should be Time period, Month
Parent (Line item 2) - Format here should be Time Period, Year

Hope that helps

Misbah

Miz Logix

Maheshkumar08

Hi Misbah,

Thanks, I have done that and earlier my mistake was i missed the Parent formula and now, Its cleared.

Quick Links

Can you help?

Unanswered questions

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
RANKCUMULATE not working when adding additional dimensions to module
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…