COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: fkli222 on 24 Jan 2017 10:11:21 AM

Title: Value is totaling at rollup instead of weighting
Post by: fkli222 on 24 Jan 2017 10:11:21 AM
Hi everyone,

I am trying to rollup a value called 'Standard Hours' which should be the same at every eList item. In Contributor, I weighted the value by 1 so it will always show the same at every level. When bringing it into my reporting, it adds up my Standard Hours at every eList level. I tried playing around with the aggregation options and  changing it from total but no luck. 

If anyone has any insight on how I can display this weighted value it would be greatly appreciated.

Thanks!
Title: Re: Value is totaling at rollup instead of weighting
Post by: MFGF on 24 Jan 2017 10:16:19 AM
Quote from: fkli222 on 24 Jan 2017 10:11:21 AM
Hi everyone,

I am trying to rollup a value called 'Standard Hours' which should be the same at every eList item. In Contributor, I weighted the value by 1 so it will always show the same at every level. When bringing it into my reporting, it adds up my Standard Hours at every eList level. I tried playing around with the aggregation options and  changing it from total but no luck. 

If anyone has any insight on how I can display this weighted value it would be greatly appreciated.

Thanks!

Hi,

Try changing it from Total to Maximum - that ought to do the trick :)

MF.
Title: Re: Value is totaling at rollup instead of weighting
Post by: fkli222 on 24 Jan 2017 11:57:59 AM
And that works, thanks so much!