Convert Period to text

Hi all,

I just had another query related to my previous one. with the help of an expert I was able to capture the next month on my time system settings. Now I need to capture the Time period into text formatted line item. i need to convert the line item Month text 2 into text formatted for Month (text 2)+1 line item. so above Mar 19 I need to have the MARCH there. I tried Name(Item(Month(Text 2)) formula and it did not work.

any thoughts?

Regards,

Accepted answers

All comments

AjayM

Hi @Jsdeloria21 ,

You don't need 'item' function within 'name' function in your formula. Please try simply name(Month(Text 2)). It should give you "Mar 19" in text format. However, if you want this to be full month name, you might need to build a mapping module (dimensioned by time) to establish full month names and refer that lineitem here.

pyrypeura

Hi,

to get name of the month as March you need to start by creating a list with months as names and 1-12 as code. Example shown in screenshot below:

Next you can finditem from this list with month number and lastly you can convert list item to text with NAME function. Formulas and results shown in screenshots below:

Michael.downer

Below works well for me and is simpler and more robust than a lookup: "TEXT(MONTH(START(PERIOD))) & "-" & TEXT(YEAR(START(PERIOD)))"

Dikshant

I agree, creating a new list with 1-12, having January till December is best solution in this case. I don't see any direct/indirect functions which calculates the same.

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…