Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
i have two text box.
first text box have to return the maximum quarter and maximum year that means : 2014-Q4
second textbox have to return the previous quarter of the maximum year that means 2014-Q3
suppose if select Year 2013 and select quarter 1 it has be return like this 2013-Q1 (tb1) vs 2012-Q3 (tb2)
Can you help me to create the formula
FiscalMonth | Month | Yr | Finquarter |
01 | Nov | 2014 | 1 |
02 | Dec | 2012 | 1 |
03 | Jan | 2013 | 1 |
04 | Feb | 2014 | 2 |
05 | Mar | 2013 | 2 |
06 | Apr | 2014 | 2 |
07 | May | 2014 | 3 |
08 | Jun | 2012 | 3 |
09 | Jul | 2012 | 3 |
10 | Aug | 2014 | 4 |
11 | Sep | 2014 | 4 |
12 | Oct | 2013 | 4 |
Current Year Quarter
=Max(Yr) & '-Q' &Max(Finquarter)
Previous Quarter
=If(Max(Finquarter)=1, (Max(Yr)-1) & '-Q4', Max(Yr) & '-Q' & (Max(Finquarter) -1))
or
//=If(Max(Finquarter)=1, Max(Yr)-1, Max(Yr)) & '-Q' & (Mod(2+Max(Finquarter),4)+1)