Forum

Welcome Guest! To enable all features please Login or Register.

Options

Previous Topic Next Topic

Páll Bjarkason		#1 Posted : Wednesday, March 19, 2014 12:05:11 PM(UTC)
Rank: Advanced Member Groups: extranet\Forum Joined: 1/13/2012(UTC) Posts: 183		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. 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? Edited by user Wednesday, March 19, 2014 1:04:31 PM(UTC) \| Reason: Not specified
		Best regards Páll, CTS
		PM

User Profile View All Posts by User View Thanks

Páll Bjarkason		#2 Posted : Thursday, March 20, 2014 10:14:08 AM(UTC)
Rank: Advanced Member Groups: extranet\Forum Joined: 1/13/2012(UTC) Posts: 183		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
		PM

User Profile View All Posts by User View Thanks

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.

Notification

Error