Forum Discussion
Revenue Trend calculation
Hi pariszhuang,
Do you use a table visual in your report? It's hard for us to understand you detail table and report structure. Please provide us the detail information and the expected result, so that we can make further analysis.
Based on my understand, you should have start date and end date column for your licence subscription. So you can check if the time point is inside this period or not.
Regards,
Charlie Liao
Dear Charlie,
As the information that I am using is company's property, it is confidential thus I can't show you the details. However, I have a seperate start date and end date column in my licence subscription. As the start and end date span over a few months. I am trying to calculate the revenue as at each time point over the different months as stated in the following table. An example is stated below:
- Eg. Customer A starts and end the licence period over 1 September to 5 December 2016 of $2,000 in total.
EOMonth September the annualised revenue contributed from Customer A is $2,000.
EOMonth October the annualised revenue contributed from Customer A is $2,000.
EOMonth November the annualised revenue contributed from Customer A is $2,000.
EOMonth December the annualised revenue contributed from Customer A is $2,000.