Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Creating a percentage data point

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

Former Member
Not what you were looking for? View more on this topic or Ask a question