See the attached BCWS Volatility Calculations worksheet as an example. Additionally, the calculations are as follows:
Maximum (max): the maximum Bcws from FutureEtc for this EndDate (including current and prior period FutureEtc entries). Defaults to current Bcws if no FutureEtc data is available.
Minimum (min): the minimum Bcws from FutureEtc for this EndDate (including current and prior period FutureEtc entries). Defaults to current Bcws if no FutureEtc data is available.
Percentage: 100 * (max - min)/ min, defaults to 0 if min does not exist.
Average: an average of all of the Percentage entries in the report. i.e. sum(Percentage) / #of periods shown in report
Prior Average: the average of all of the Percentages in the report prior to time now
Future Average: the average of all of the Percentages in the report after time now