en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Páll Bjarkason  
#1 Posted : Wednesday, March 19, 2014 12:05:11 PM(UTC)
Páll Bjarkason
Rank: Advanced Member

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

I want to hide all hideMultiAgeIntermediate with a value greater than 1. The problem is that hideMultiAgeIntermediate does not count as expected.

hideMultiAge – counts all siblings giving the total.
allcount(d1, all(s), m1)

hideMultiAgeIntermediate - counts all siblings starting from 1 and up
allcount(d1, d1:0(s), m1)

In this screenshot I have chosen 2 clients via global criteria on the client dimension. The hideMultiAgeIntermediate column counts correct.
UserPostedImage


There is no global criteria on the client dimension in the screenshot below. The same 2 clients are highlighted in the blue box. The problem is that the client with Total 89-90 now does not count correctly via hideMultiAgeIntermediate. It should have been 1 and 2 but it is 1 and 1! I don’t understand how hideMultiAge can be correct and hideMultiAgeIntermediate is incorrect. Can anyone please figure out what the problem might be?
UserPostedImage

Edited by user Wednesday, March 19, 2014 1:04:31 PM(UTC)  | Reason: Not specified

Best regards

Páll, CTS
Páll Bjarkason  
#2 Posted : Thursday, March 20, 2014 10:14:08 AM(UTC)
Páll Bjarkason
Rank: Advanced Member

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

With the aid of expert guidance from TARGIT, the problem is now located.
A sort on a calculation (hideMultiAge) wronged the calculations.
Both calculations should of course count correctly and now they do too!
Thanks mate.


Now the Visibility agent works correct.
Using the Visibility agent corrupts the automatic totals. This tweak solves wrong totals.

Showing right total for the clients:
if allcount(d1, all(c), m1) > 0 then count(0, all(v,r0), m1) else sum(0, 0, m1)
Mind the r0 is used as there are 2 levels of toals. r0 counts the leaf level and not the intermediate (hidden) total level.

Another calculation is used to show all the clients’ time in the visible row.

Edited by user Thursday, March 20, 2014 11:18:05 AM(UTC)  | Reason: Not specified

Best regards

Páll, CTS
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