Current Quarter Formula:
Let vCurrentQtr = ceil(month(Today())/3);
‘Q’ & $(vCurrentQtr);
Previous Quarter Formula:
Let vPreviousQtr = if(Mod(fabs(vCurrentQtr-1),4)=0, 4, Mod(fabs(vCurrentQtr-1),4));
Previous Quarter Year Formula:
Let vCurrentYear = Year(Today());
Let vPreviousYear = vCurrentYear;
Let vPrevQtrYear = if (vPreviousQtr=4, vPreviousYear, vCurrentYear);