4 Replies Latest reply: May 15, 2018 12:59 AM by siddharth soam

# Want to calculate annualized revenue

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 <3,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

• ###### Re: Want to calculate annualized revenue

>>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...

• ###### Re: Want to calculate annualized revenue

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

• ###### Re: Want to calculate annualized revenue

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?

• ###### Re: Want to calculate annualized revenue

Hi Jonathan,

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