This content has been marked as final.
Show 3 replies

Re: Displaying KPIs for Forecast Variance
Sunny Talwar Jun 9, 2016 3:41 PM (in response to Prasenjit Gupta)Overall % looks good to me, you jut need to use fabs to find the absolute value for variance > Sum(fabs(Variance))/Sum([Forecasted Value])
or this if Variance is calculated as well:
Sum(fabs([Forecasted Value]  [Actual Value]))/Sum([Forecasted Value])

Re: Displaying KPIs for Forecast Variance
Sunny Talwar Jun 9, 2016 3:47 PM (in response to Sunny Talwar )The Average % can be calculated using this:
=Num(Avg(fabs([Forecasted Value]  [Actual Value])/[Forecasted Value]), '##.00%')
Overall%
=Num(Sum(fabs([Forecasted Value]  [Actual Value]))/Sum([Forecasted Value]), '##.00%')

Community_220285.qvf 176.0 K

Re: Displaying KPIs for Forecast Variance
Prasenjit Gupta Jun 10, 2016 1:02 AM (in response to Sunny Talwar )Thank you, I will check it and will respond back over the weekend.

