Hi.
I have a rather comprehensive calculation, where i every month calculate efficiency and productivity based on our nomenclature (kontoplan). However once in a while I experience that a new account has been taken in use, and therefore my calculation will fail.
E.g. my calculation for productivity is
-sum(d1(l3), 0, m1) / (sum(d5(l5), 0, m1) + sum(d36, 0, m1))
But last month a new account was taken in use, so I needed to change "sum(d36, 0, m1)" to "sum(d37, 0, m1)", so my calculation os now:
-sum(d1(l3), 0, m1) / (sum(d5(l5), 0, m1) + sum(d37, 0, m1))
I would like to make a calculation that can be used every month without having to make changes, so is it possible to show all accounts even though they are not in use yet? That way I would be able to make a durable calculation.
http://screencast.com/t/09tfU1NuThank you.