Compare Quarters

[#1]

I am using this formula to extract the quarters from my date field.

= 'Q' & Ceil(Month([Create Date])/3) & '-' & Year([Create Date])

From this I get Q1-2016, Q2-2016, Q3-2016, Q4-2016. What I am having an issue putting together, a text field with the % change of:

Q3-2016 vs Q4-2016

[maxgro · Accepted solution]

I think with quarter serial field in a calendar (create the calendar in the script)

Look at Gysbert's answer here

Re: Week to week and quarter to quarter comparison

[#3]

Thanks for the reply Maxgro, I will give it a try.