i want to get differences between two calculated fields.Below am attaching workbook.3 nd 4 columns are calculated fields for (average n weeks) - (yesterday).
The requirement is simple i have to subtract yesterday value with average of parameterised weeks(ex:3) it should show the differences for the changed weeks count.
Here i tried 3rd and 4th column but the results arent correct.
It's the way you're doing [diff_sub]
You want to do SUM([Average N weeks]- SUM([yesterday_new]).
You are doing SUM( [Average N weeks] - [yesterday_new] ).