Welcome Guest! To enable all features please Login or Register.
Go to last post Go to first unread
#1 Posted : Wednesday, December 4, 2013 3:36:42 PM(UTC)
Rank: Advanced Member

Groups: extranet\Forum
Joined: 7/9/2013(UTC)
Posts: 39


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.


Thank you.
#2 Posted : Wednesday, December 4, 2013 3:43:58 PM(UTC)
Rank: Administration

Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 514

Hi Morten,

Or you could change your calculation to always refer to the correct column. So instead of using sum(d37, 0, m1) you should change it once and for all to:

sum(@"[Leverancer].[1094-Salg af varer udenfor EU]", 0, m1)

I am not sure I can see everything in the screenshot, so I am assuming your column reference is to a two-level hierarchy as referred to in my example.

Best regards,
Ole Dyring
Users browsing this topic
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.



We use cookies to improve your site experience, but they also provide us with information on your use of our website.
To find out more about the cookies we use and how to delete them, see our Privacy Policy. By continuing to browse the site, you are consenting to our use of cookies.