How to obtain Period Format item for out of time range month

Tsuyoshi_Inoue

Hi experts,

Could you please help me, obtaining period formatted item for out-of-time-range month?

example)

Financial year: 2018/4 ~2022/3

target month: 2018/3　➡ Mar 18 (expected), Blank(actually)

Accepted answers

Sheethal

If you are fine to show the outcome in text, you can try the following method. This will be a easier method if the data is only for display purpose.

Create a mapping list to map the month in numeric (3) to month in words (Mar) as shown in the screenshot.

Then you can use "CODE(FINDITEM(Mapping, RIGHT(Data, 1))) & " " & MID(Data, 3, 2)" formula to get the output in text format.

Screenshot Module.JPG

All comments

JaredDolich

@Tsuyoshi_Inoue

Can you try the ADDMONTHS() function.

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/ADDMONTHS.html

Also, you can always create a time range that goes back one year. Just use a system module for the lookup so you aren't making your modules overly big.

Misbah

@Tsuyoshi_Inoue

Add a dummy Time range of FY18 in your model.

Use PERIOD(Date) in your target line item - you should be good

Sheethal

If you are fine to show the outcome in text, you can try the following method. This will be a easier method if the data is only for display purpose.

Create a mapping list to map the month in numeric (3) to month in words (Mar) as shown in the screenshot.

Then you can use "CODE(FINDITEM(Mapping, RIGHT(Data, 1))) & " " & MID(Data, 3, 2)" formula to get the output in text format.

Screenshot Module.JPG

Kanishq17

Hi,

You can create a time range for FY18 i.e from April 17- March 18 separately,

Once a time range is created, all its periods are available along with model timescale periods as period format

as shown

Hope this helps

Quick Links

Can you help?

Unanswered questions

Issue with Anaplan tab in Salesforce
I have installed the Anaplan app in Salesforce, but have been receiving an error. In the Anaplan part it asks for you to contact support, but does not provide any details into how to do this, just raising a ticket in the portal? WOuld be great to have more information.…
Data Integration to Fluence workspace
Hello Everyone, I am seeking guidance on how I could create a workflow process in Fluence consolidation workspace, using the ADO import task. Does anybody know what kind of information I need to fill in these fields? I have watched the ADO training but only explains the data transformation and integration within Anaplan…
Pagination in Management Reports Without splitting Parent Blocks
Hi I would like to set up pagination in management reports by assigning a page number to a list item and its parent but I also want to be able to keep a block of parent and list items together and not split over two pages. E.g. Parent 1 - 1 Child 1 - 2 Child 2 - 3 Parent 2 - 4 Child 3 - 5 Child 4 - 6 Child 5 - 7…