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

Highlighted
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)

4 REPLIES 4
Highlighted
Master Anaplanner/Community Boss

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
Highlighted
Master Anaplanner/Community Boss

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

Highlighted
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

 

Highlighted
Super Contributor

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