on 10-23-2015 12:50 PM
Hi ,
I have created aging report as below . I also need to display each column/key figure result as the percentage of the last column(key figure).
I still need to display the totals as well for each column.
I need to display the percentage , for eg. for "180 days" column , it should show in result row as How much Percentage is this with regards to "Amount in Transac curr" column
could you please suggest if this is possible through some property.
could you please also suggest if I can change the "Overall Result" to "Sum" , in the last result row.
Hi Raju,
I need to display the percentage , for eg. for "180 days" column , it should show in result row as How much Percentage is this with regards to "Amount in Transac curr" column
Create a new formula(ex: 180days%) --> 180days / amount in trasc curr *100
you can repeat the same formula for other days percentage.
could you please also suggest if I can change the "Overall Result" to "Sum" , in the last result row.
overall result is already in summarizing values for all rows and keyfigure (expect for "amount in trasc cuu" & test).. for these two key figure, you can goto properties and choose the calculate result as : summation.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Raju,
Try the solution as suggested by Jyothi.
Also you can use percentage functions while creating formula to see the % . You can change overall result to summation, by changing the property of 'calculate result as' to 'Sum' in calculations tab.
Regards,
Vengal.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
If you move this question to "SAP Business Explorer (SAP BEx)" forum, may be you will get some suggestions.
You can try Exception aggregation property. But that would affect whole column's value. But sounds like you want to have percentage calculation only on result row!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.