Time Function

NancyKhurana
Occasional Contributor

Time Function

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
LipChean_Soh
Certified Master Anaplanner

Re: Time Function

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

 

View solution in original post

2 REPLIES 2
abhay.kanik
Regular Contributor

Re: Time Function

@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

LipChean_Soh
Certified Master Anaplanner

Re: Time Function

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

 

View solution in original post