Simple % Measure in Universe

[system]

I don’t know of any way to roll up a percentage at universe level - you need to do it at report level. Have you searched here? I’m sure there was a really good explanation of why it doesn’t work. Or it might be on Dave’s blog.

Debbie

Edited to add - here’s what a search pulled up:

120×120 10.4 KB

I am trying to calculate a % based on two objects - it needs to be done in the Universe so that I can perform further averages from the object. The first object is: [QRY_Year 1 R Pupils by SOA] Code: @Select(3yearcensusdata\Count of UPN) - this returns a correct value in the report The second object is: [Qry_Year 1 - Health Data Reception Pupils by SOA] Code: sum(Health Data.Numbers) If I calculate these in the report as: =[QRY_Year 1 R Pupils by SOA]/[Qry_Year 1 - Health Data Recepti…

120×120 10.4 KB

Hi Issue-Calculating Percentage in Universe I have two measure objects which are summed up: Summary Cal Qty and Generic Sample Qty and the percentage calculation should be (Summary Cal Qty/Generic Sample Qty )*100 I have used the following formula ((@Select(Qwx Summary Calculation Fact All\Summary Calc Qty)+ 0.0000 )/ @Select(Sample Size Fact\Generic Unit Sample Qty)) * 100 It gives me a multivalue error in my report in some rows Note :The Measure Objects are set to sum in properties as th…

The second contains a link to Dave’s blog which explains how to deal with percentages and averages and how to use a new feature in R3 which might help you.

---

Debbie (BOB member since 2005-03-01)