Time Function

NancyKhurana
NancyKhurana
in Modeling

How can I pull quarter values (Q1,Q2,Q3,Q4) from Expected Invoice Date ? 

NancyKhurana_0-1625565285690.png

The module has no time scale applicable.

NOTE:  Time Settings doesn't have quarter totals enabled . 

NancyKhurana_1-1625565424873.png

 

 

Tagged:

Best Answer

  • LipChean_Soh
    LipChean_Soh
    Answer ✓

    Hi @NancyKhurana 

     

    LipChean_Soh_0-1625572502066.png.     LipChean_Soh_1-1625572516523.png

     

    1. Even if your model calendar doesn't have quarter total turned on, you can still create a Time Range with 'Quarter' checked.

     

    LipChean_Soh_2-1625572568751.png

    LipChean_Soh_0-1625572752018.png

    2. You can select 'Quarter' from the 'Period' formatted line item, and apply the PERIOD() formula.

     

    Thanks,

    LipChean

     

Answers

  • abhay.kanik
    abhay.kanik

    @NancyKhurana 

    Create a line item for quarter and keep it time formatted- quarter 

     

    Quarter.PNG

    apply formula period(date line item) . This will give you quarters irrespective of the summary in model calendar

    Quarter.PNG

     

    Thanks

    Abhay

Categories