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

Tsuyoshi_Inoue
Occasional Contributor

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

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)

1 ACCEPTED SOLUTION

Accepted Solutions
Sheethal
Certified Master Anaplanner

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

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.

Screenshot.JPG

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

 

View solution in original post

4 REPLIES 4
JaredDolich
Moderator

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

@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.


Jared Dolich
Misbah
Moderator

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

@Tsuyoshi_Inoue 

 

Add a dummy Time range of FY18 in your model.

 

Misbah_0-1589375224204.png

 

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

Sheethal
Certified Master Anaplanner

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

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.

Screenshot.JPG

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

 

View solution in original post

Kanishq17
Community Boss

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

Hi,

 

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

Kanishq17_1-1589392352602.png

 

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

as shown

 

Kanishq17_0-1589392296749.png

Hope this helps