cancel
Showing results for 
Search instead for 
Did you mean: 

Creating a percentage data point

Former Member
0 Kudos

Hi,

I am trying to create a data point at the universe level that computes the achievement percentage of sales vs target. At the most granular level, the value is correct, but rolling up, it simply sums up the percentage instead of calculating the value. I am able to get the correct percentage if I define at the report level, but I am wondering if I can do this at the universe level so that it can be a re-usable data point for users.

Sample data:

Achievement  =  Sales/Target

Year     Quarter     Target     Sales     Achievement

2010     Q1             100        50          0.5

2010     Q2             200        175        0.875

If Achievement is defined at Universe-level, I get the below values:

Year     Target     Sales     Achievement

2010     300        225         1.375

When the correct value should be as below:

Year     Target     Sales     Achievement

2010     300        225         0.75

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Ednalynn,

You must have defined 'Achievement' object as a measure in the universe.

The measure is this scenario is non-additive; however, it seems like the default projection of this measure is set to Sum and therefore, the values are getting aggregating automatically when the grain is increasing.

Can you try using the projection as 'None' and check if it helps?

Regards,

Yuvraj

Former Member
0 Kudos

Hi Yuvraj,

I have tried to set it to None, but now the data will not roll-up. Below is the result:

Year     Target   Sales     Achievement

2010    100        50          0.5

2010     200       175        0.875

I was hoping to get something like this:

Year     Target     Sales     Achievement

2010     300        225         0.75

Former Member
0 Kudos

Hi Ednalynn,

In that case, the best option seems to be to do this at Webi level.

Can you try this and check if it works at universe:

Achievement = Sum(sales) / Sum(Target).

Keep the projection as None as it is a ratio and is non-additive.

As far as I am aware, rolling up can only be done automatically in case of additive measures like Sales, Revenues, Costs, Prices and not in case of non-additive measures like this.

Regards,

Yuvraj