New to vsb.net...also new to the coding world. Go easy on me!
I have a report that calculates call center rep statistics over a specific 3 month period. This timeframe is called "Transition." I have the columns that provide the data values for each month for each statistic. I am trying to add
a column that provides the cumulative average of these statistics at any given time when the report is generated during Transition.
I can insert an expression that calculates the average over a 3 month period. That's no problem. The part I'm having trouble with is an expression that calculates the cumulative average if the report is generated prior to the end of the 3 month
period. If the report is generated after only 2 months in transition...I need the average of the data values for only 2 months, not 3. How can I create this dynamic expression in the expression dialog box for vsb.net 2005?