en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Morten  
#1 Posted : Friday, October 18, 2013 8:55:19 PM(UTC)
Morten
Rank: Advanced Member

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

Hej.

Jeg har brug for at lave nogle beregninger på fx kapacitetsgrad ud fra en kontoplan.
Dette regner vi ud som nettofortjeneste/timeforbrug - dette er to tal, som vi bliver udregnet i et hierarki, som er opbygget i vores kontoplan-dimension.

Min udfordring er, at jeg ikke kan lave en avanceret beregning direkte på disse to tal, men er nødt til at gøre det direkte på nederste niveau (de enkelte konti). Ellers bliver resultatet forkert. Dette betyder at min formel kommer til at kalkulere med ca. 30 konti på nederste niveau frem for de to sumkonti, som jeg har behov for.

Kan det virkerlig passe, at man ikke kan lave en avanceret beregning på poster, som ikke er på nederste niveau i et kontoplanhierarki?

Mvh Morten.
Páll Bjarkason  
#2 Posted : Monday, October 21, 2013 10:24:40 AM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 164

Dear Morten

Could you please submit a picture of your problem?
Best regards

Páll, CTS
Morten  
#3 Posted : Tuesday, October 22, 2013 8:21:05 AM(UTC)
Morten
Rank: Advanced Member

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

Her kommer et med problemet:
http://screencast.com/t/rA96hs1sLnE9

Og her er min foreløbige løsning, hvor alle niveauer er foldet helt ud, og hvor hver enkelt felt lægges sammen (meget omstændigt):
http://screencast.com/t/08IF3Dht7AG

Edited by user Tuesday, October 22, 2013 8:31:01 AM(UTC)  | Reason: Not specified

Páll Bjarkason  
#4 Posted : Wednesday, October 23, 2013 11:50:17 AM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 164

For insight on calculations (As a measure, levels etc.) see the great On-Demand webinar by Ole Dyring: TARGIT Tips & Tricks Webinar, March 2012 - Get familiarized with the formula syntax for client based calculations.
Note: At the end of the webinar Ole explains how to do level referencing. Try it out.

Edited by user Wednesday, October 23, 2013 12:36:13 PM(UTC)  | Reason: Not specified

Best regards

Páll, CTS
Morten  
#5 Posted : Friday, October 25, 2013 11:17:03 PM(UTC)
Morten
Rank: Advanced Member

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

Hi.

Great. Just what I needed. Thanks.

Morten
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