How to convert month to text?

wld002

I am needing to convert month to text as we have a specific nomenclature we use for our company (i.e, if the current month/pay period is May but the pay accrual month is April I am needing to have a text display for May 25 as AprilPayMay25). I've done a lookup table in the past but was hoping for a formula that could do this for a more efficient build.

luke_e

Definitely set this up in a staging module/line that is only dimensioned by time.

Simply put, converting month to text is as simple as NAME(ITEM(TIME)). However, in your example, looks like you're wanting to have a different naming convention which joins periods.

You could use LEFT() and RIGHT() functions to extract the elements you want before joining. However, you'd still need to calculate the current month NAME() and the previous month NAME() before joining together.

e.g LEFT(Prior Month Text),3) & "Pay" & Left(Current Month Text,3) & RIGHT(Current Month Text,2)

Text functions hit the model a bit harder so ideally, you'd stage the logic out, but the new calculation effort column should give you an idea.

SriNitya

Hi @wld002
You can achieve this see the attached screenshots.

If Previous Month Year Display is not needed, then using left function fetch only month and then concatenate it.

SriNitya

Text Concatenation | Model Optimization Team series — Anaplan Community- Refer this article to learn more about the Text concatenation optimization