TOTPD (Total Percentage Difference )

Description

It is the total deviation across all the time periods. It is the total percentage difference between the first series minus the second series.

Formula

% Difference = (SUM(A) – SUM(F))/SUM(A)

Where F = forecasts (expected values or unknown results) and A = observed values (known results).

Example