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

Dividing (not formating) all the results by 1000
Hello, Is there a quick way, in Anaplan XL to divide all the results by 1000 without creating a measure for every row or every column?
ADO connection from postgreSQL
Hi everyone, I am trying to create a connection ADO from PostgreSQL, but I consistently receive the following error: Failed to establish a connection The following message was sent from the target system: The SSL certificate is either invalid or not in unencrypted PEM format. Please check your certificate and try again.…
RTO and RPO details required
For auditing purpose I need RTO and RPO details. Could you please share the details and also along with the source URL.