Skip to Content

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

Calculation

I am getting data from SQL server like below:

0calmonth 0amount

01.2000 100

02.2000 200

03.2000 -200

04.2000 300

......

01.2001 0

02.2001 100

03.2001 150

..

Now in Query designer I need to create output as below:

CalMonth 01.2000 02.2000 03.2000 04.2000 ....................................01.2001 02.2001 03.2001

Sum(0amount) 100 300 100 400 0 100 250

If this was just one column, I would have created this easily with the help of customer exit variable ( When I know the last Calmonth), but in this case i need to add this for all months. How I can handle this scenario?

Regards

Amandeep Sharma

Edited by: AmanSharma123 on Jun 10, 2011 7:20 AM

Former Member
replied

Hi,

My suggestion will be to do this calculation at infoprovider level.

In BEx, you have one option. Add Calmonth and Amount in the Column. Go to Key Figure properties -> Calculate Single Value as -> Cumulative along the Row.

But this is just a display property, it does not actually calculate. SO you cant use these values for further calculations. If suppose you filter out one month, value of that month will be ignored

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question