I am working on below report.
The report has actual hours and forecast hours grouped by resource
name on a monthly basis per project.
I am utilizing a matrix and it looks like below.

Resource Name


                  Jan-07 Feb-07 Mar-07
             Actual|Forecast Actual|Forecast Actual|Forecast
Project Name1
Project Name 2
Project Name 3
...


The actual and forecast hour information is stored in two views along
with month and project name information. I am doing a union of the
the two views to produce the above matrix view.


Now, I need to add 'variance' difference between actual and forecast
hours in the mix. The new matrix should look like below.


Resource Name


       Jan-07 Feb-07
       Actual|Forecast|Variance Actual|Forecast|Variance
Project Name1
Project Name 2
Project Name 3
...


I am having trouble calculating variance in the above solution. I am
wondering if any SQL/SRS experts/gurus can help me with this problem
or suggest a different method.


Let me know if I can answer any questions to explain the issue
further. Thank you in advance for your time and effort.


Avi