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

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

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/09tfU1Nu

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

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

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
I work as an employee with TARGIT A/S. Any statement made by me in this forum represents my own opinion and state of mind, and is not necessarily related to or representative of TARGIT A/S.

UserPostedImage Ole Dyring
Users browsing this topic
Anonymous
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.

Notification

Icon
Error