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)
10|10000 characters needed characters exceeded

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.

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.

10|10000 characters needed characters exceeded
• Oct 26, 2015 at 09:47 AM

Hello Raju,

How to use Percentage Functions in Bex Query Designer

use % function as mentioned.

Regards,

Hitesh