nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Text to quarter ?

Hello Everyone,

what is the best formula that we can use to go from this to this:

Txt Period "Format Text" (Example: Q1 FY24) ===> Quarter "Format Quarter" (Example: Q1 FY24)

Tags

Modeling

Model Builder

Anaplan Community

Accepted answers

ILYAS
Hi,
Text - Time Period → Use FINDITEM.
FINDITEM(TIME, Text) Format line Item as Time Period: Quarter.
let me know if it helps.

Yes it works thank you so much

All comments

ILYAS
Hi,
Text - Time Period → Use FINDITEM.
FINDITEM(TIME, Text) Format line Item as Time Period: Quarter.
let me know if it helps.

Yes it works thank you so much

Quick Links

Can you help?

Unanswered questions

Are we allowed to create a practice dataset to simulate a real model build (Talent Builder Program)
Done with the course but want to practice a bit more before I take the Level 1 exam
Anaplan Analyst performance on large, sparse models
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.
Expand or collapse grid rows: how to publish level 1 and 2 in a 5-level hierarchy
I have a question about the new Expand or collapse grid rows option. Is it possible to publish a grid containing a 5-level hierarchy so that all items from levels 1 and 2 are always visible? And I do not want to use a filter for this.