Skip to Content
avatar image
Former Member

Query Result display for percentage

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.

query result.png (26.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 23, 2015 at 03:03 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 26, 2015 at 06:24 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 26, 2015 at 09:47 AM

    Hello Raju,

    please refer below link:

    How to use Percentage Functions in Bex Query Designer

    use % function as mentioned.

    Regards,

    Hitesh

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 23, 2015 at 02:01 PM

    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!

    Add comment
    10|10000 characters needed characters exceeded