How to calculate within specific tenure?
I am looking for the best solution how calculate/distribute an amount within specific tenure once it was triggered by a variable.
1 million of revenue will be recognized equally over 24 months once the project is completed.
The 1st month of the recognition starts on the following month once the project completed (the variable).
The revenue recognition will ends after the 24th month from the 1st month of recognition. Or it will end once cumulative revenue is 1 million
Your suggestion if much appreciated.