Hello again,
Niels, thank you for the fast reply and the description on how formulas are defined - this subject has been on my mind for quite some time :-).
As to the problem at hand, my table is as following:
When I define my formula for the variance between december and september I get the following: sum(d-10,0,m1)-sum(d-1,0,m1) where I assume the d-10 is referring to the current column minus 10 (which is december). Once the month turns to November, my variance column will still be sum(d-10,0,m1)-sum(d-1,0,m1), and the d-10 is now refering to the month January - the correct reference for the formula should be d-11.
How do I define my variance formula that for any given month return my "current month minus 1" subtracted december - hence a dynamic formula with a fixed reference ?
MY TABLE:
Group December Januar Februar Marts April Maj Juni Juli August September Variance
A 5 7
B 6 10
C 5 8
D 1 3
E 1 6
(the example numbers should be for december and september respectivly)
And as for the advanced training, I will take it up with my boss :-)
Best regards
Martin
Edited by user Monday, October 21, 2013 1:11:28 PM(UTC)
| Reason: Not specified