cancel
Showing results for 
Search instead for 
Did you mean: 

How to calculation percentage of fees in each country for a Charge Code?

lenis_11
Discoverer
0 Kudos
106

I have a use case to calculate the % of fees for each country by the formula, fees for each country divided by total for all the countries for each charge code. I tried creating aggregation for denominator by mentioning only charge code in aggregation dimension but it is giving the same value as Fees. What should be done to calculate the sum of countries in a charge code?

As shown below Aggregation 1 is my calculation based on Charge code.

moshenaveh
Community Manager
Community Manager
0 Kudos

Welcome to the SAP Community! Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Secondly, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html as well, as that will help you when submitting questions to the community.

Finally, I recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

Accepted Solutions (1)

Accepted Solutions (1)

N1kh1l
Active Contributor

lenis_11

lenis_11To get total for all countries for each charge code, create a restricted measure with constant selection as shown below. Your aggregating dimension would be country

Br.

Nikhil

lenis_11
Discoverer
0 Kudos

Thanks Nikhil!

Answers (0)