Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Trying to derive Current Quarter and Previous Quarter for the Value available and have stuck in Detrmining Previous Quarter.
The value available is :
Current is : Q12015.
How to determing Previous , i.e. here : Q42014 ?
Any help appreciated.
Thanks!
Create AutoNumber for Quarter in your Script..
for string
=if(left('Q22015',2)='Q1', 'Q4' & (right('Q22015',4)-1), 'Q' & (mid('Q22015',2,1)-1) & right('Q22015',4))
replace 'Q22015' with your quarter field
=if(left(Reporting_Quarter,2)='Q1', 'Q4' & (right(Reporting_Quarter,4)-1), 'Q' & (mid(Reporting_Quarter,2,1)-1) & right(Reporting_Quarter,4))