Convert date type to period

Monpero · 2023-03-29T14:12:52+00:00

There was an error rendering this rich post.

Monpero

Hi All,

I converted this date format into period using this formular

PERIOD(DATE(VALUE(RIGHT(Reporting Period, 4)), VALUE(LEFT(Reporting Period, 2)), 1))

How can this date format be converted to period in Anaplan just like above. It doesn't work with the formula above. Please is there a workaround on converting this to period format.

Accepted answers

HimanshuRaj

Hi @innocent

You can also use below formula to convert text month to time formatted month list

FInditem(TIME, substitute(reporting period, "-"," "))

Cheers!!

All comments

rob_marshall

@innocent

Instead of loading in as text, change the format of the line item to Time Period.

Monpero

Thanks @rob_marshall it is a Master Data Module with no time dimension.

So when I had the format to Time Period Month and import it throws this error to me

HimanshuRaj

Hi @innocent

You can also use below formula to convert text month to time formatted month list

FInditem(TIME, substitute(reporting period, "-"," "))

Cheers!!

Monpero

Thanks a lot @Himanshu1998 that did the trick.

seymatas1

@Monpero

Add a time dimension to the master data module.

Refer to this article by @rob_marshall

https://community.anaplan.com/discussion/48866/oeg-best-practice-data-hubs-purpose-and-peak-performance

Quick Links

Can you help?

Unanswered questions

Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…
Curious Comparison: Forecast Modeling for Unusual Products
I've been experimenting with some forecast modeling techniques in Anaplan recently and decided to test them on a few quirky, offbeat product categories just for fun. One of the categories I played around with was love dolls—yes, you read that right. It actually turned out to be more interesting than expected. Unlike…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled