I need to covert the text field range to a period number, what should be the formula for that?
I am getting the text range input as: JAN 2019 - DEC 2019 (in a single text cell)
I need an output as period number. 1 for Jan 2019 in one line item and in the second line item 12 for Dec 2019.
Thanks for the help 🙂
Go to Solution.
See if this helps.
View solution in original post
Hi @ShivankurSharma ,
You can use Anaplan left/Right/Mid function to get the Year value in separate line item and then use Finditem to get the Year time period.
If you still need some help, I can post some formula screenshot.
Date transformations are at the top of any modeler's list of things to do. So, great question.
First thing you have to do is convert the text to a date. Then a date to a period.