Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
>>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...
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
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?
Hi Jonathan,
Exactly that, I want to generate an expression for calculating my revenue till Q3 quarter for FY18.