Quarter to month

ILYAS
ILYAS
in Modeling

Hello ^^

How can I convert a line item formatted in quarters (e.g., Q4 FY23) to a line item formatted in months, displaying the last month of each quarter

Q4 FY23 =⇒ Dec

Q1 FY23 =⇒ Mar

etc

Thank you

Tagged:

Best Answer

  • pyrypeura
    pyrypeura
    Answer ✓

    Hi,

    You can use also PERIOD(END()) formula in month formatted line item with Quarter time scale as in below.

    image.png
    image.png

Answers

  • Dikshant
    Dikshant
    image.png

    This is the expected result and here is how you can achieve it. Target modules is SYS Time Setting by Quarter.

    Create a line item Closing Month. Create a module SYS Time Setting by Month, and a line item - Month

    image.png
    image.png

    Summary has to be: Last non-blank

    Format: Month

    Refer this line item directly in the target module (SYS Time Setting by Quarter)

Categories