 Rank: Member
Groups: extranet\Forum
Joined: 8/17/2018(UTC)
Posts: 9
|
Hey everyone I created a new column with a custom calculation: Target Progress. This column looks at the % difference between the invoiced amount and the target that was set (Invoiced Gross / Forecast). On an aggregated level, it should show the average, instead of the recalculation of the column. For example, all children of the parent level have a percentage of 0. Aggregated, this should show a total of 0%. Instead, the values are aggregated and then the column is calculated. In the example here, the Target progress is 64.14% instead of 0%.  Can somebody help me out? Thanks! Kind Regards Jacob
|
|
|
|
|
|
 Rank: Administration
Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 510
|
Hi Jacob,
You could do this by adding another calculated column to your crosstab:
Target Progress 2: if allcount(d1, all(c), m1) = 0 then sum(c1, 0, m1) else avg(c1, all(c), m1)
If you have multiple hierarchy levels or if you need the Grand Total to be correct as well, you may need to repeat it into another calculated column:
Target Progress 3: if allcount(d1, all(c), m1) = 0 then sum(c2, 0, m1) else avg(c2, all(c), m1)
Etc.
BR / Ole |
Ole Dyring |
|
|
|
|
|
Rank: Member
Groups: extranet\Forum
Joined: 8/17/2018(UTC)
Posts: 9
|
Thank you, Ole! This helped me :)
|
|
|
|
|
|
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.