Howdy:
I'm working on a report that will display the deferred revenue across many months, usually 1 to 2 years. Each month a small portion of deferred revenue is recognized and subtracted from the total deferred revenue.
Example:
The original sales transaction is for $12,000. Each month 1/12th or $1000.00 will be recognized as revenue, so that by the end of the year all $12,000 is recognized.
In the cross tab report, I want to display in each column the deferred amount, $1,000 and the remainder of the deferred amount, $11,000 for the first month, and $10,000 for the second month and so on.
Jan 2006 Feb 2006 March 2006
1,000 11,000 1,000 10,000 1,000 9,000
Does anybody have any ideas on how I can achieve this goal?
Any input would be appreciated.
Ralph
I'm working on a report that will display the deferred revenue across many months, usually 1 to 2 years. Each month a small portion of deferred revenue is recognized and subtracted from the total deferred revenue.
Example:
The original sales transaction is for $12,000. Each month 1/12th or $1000.00 will be recognized as revenue, so that by the end of the year all $12,000 is recognized.
In the cross tab report, I want to display in each column the deferred amount, $1,000 and the remainder of the deferred amount, $11,000 for the first month, and $10,000 for the second month and so on.
Jan 2006 Feb 2006 March 2006
1,000 11,000 1,000 10,000 1,000 9,000
Does anybody have any ideas on how I can achieve this goal?
Any input would be appreciated.
Ralph