
Re: Forecast Accuracy Help
Roland Kunle Oct 7, 2011 10:14 AM (in response to Justin Kelly)Hello Justin,
take a look at my straight table of attached app.
Note that between the brackets are [columnnames] of the chart, not fields.
HtH
Roland

36854.Forecast Accuracy.qvw 156.2 K

Forecast Accuracy Help
Justin Kelly Oct 7, 2011 4:21 PM (in response to Roland Kunle )Sorry, Roland. I made a mistake in my original post.
The total ABS% should be 78.28%, which is the sum of the ABS column divided by the sum of the Forecast column. The 23.59% is the percentage.
I still haven't been able to figure out a formula to get the Total ABS column to be the absolute variances without have to click "Sum of Rows."

Re: Forecast Accuracy Help
Roland Kunle Oct 8, 2011 11:58 AM (in response to Justin Kelly)Hi Justin,
an expression is valid for the whole column (same calc. for all "cells" of that column). So try this expression in an add. column:
=[ABS] / sum(TOTAL Fcst)
with %format and also check "Sum of rows"
HtH
Roland



Re: Forecast Accuracy Help
Purna Cheekati Oct 14, 2014 10:29 PM (in response to Justin Kelly)Are you able to find the solution for this question?