03-05-03, 07:23 #1Registered User
- Join Date
- Mar 2003
- Kuala Lumpur, Malaysia
Unanswered: Compare Year to Year Figure :eek: (last year VS this year figure)
I'm having problem in getting a correct DTS/SQL code to store both Current_Year_Balance and Previous_Year_Balance.
For example, The figure have to compare "different figure" between "March 2003 balance" with "March 2002 balance" and so on for each following month. Later on from the "different" I get, I will need to compute the variance.
Can anyone provide me with that information. A thousand thanks!