Want to calculate annualized revenue

[siddharthsoam]

Hi I want to calculate annualized revenue . My data structure is as follows:

Fiscal Year	Quarters	Accounting Period
FY17	Q1	1
FY17	Q1	2
FY17	Q1	3
FY17	Q2	4
FY17	Q2	5
FY17	Q2	6
FY17	Q3	7
FY17	Q3	8
FY17	Q3	9
FY17	Q4	10
FY17	Q4	11
FY17	Q4	12
FY18	Q1	1
FY18	Q1	2
FY18	Q1	3
FY18	Q2	4
FY18	Q2	5
FY18	Q2	6
FY18	Q3	7
FY18	Q3	8
FY18	Q3	9
FY18	Q4	10
FY18	Q4	11

Expected Outut-Q1,Q2,Q3

I want to compute an expression where if my count of accounting period corresponding to a quarter ❤️,then all quarters before it should be displayed. So for example in the above table count of accounting period corresponding to Q4 is 2, then my output should display  Q1,Q2,Q3

[jonathandienst]

>>So for example in the above table count of accounting period corresponding to Q4 is 2, then my output should display  Q1,Q2,Q3

But in your table, Q4 only corresponds to accounting period 9, 10, 11...

[siddharthsoam]

Hi Jonathan,

Let me be elaborate..

My accounting period represents months, so accounting period 1 is April and so on.

When I am saying count of accounting period I meant count of the number of months for that quarter.

So my last quarter for FY18 has 2 months in it.

I hope I have clarified

[jonathandienst]

OK, I understand that. Now

>>then my output should display  Q1,Q2,Q3

How do you want to display the Q1-Q3? Listbox, selection, text box....

Or do you mean to exclude the last Q if it's not yet complete?

[siddharthsoam]

Hi Jonathan,

Exactly that, I want to generate an expression for calculating my revenue till Q3 quarter for FY18.