Announcements
cancel
Showing results for
Did you mean:
Creator III

## Percentage Calcualtion.

Hi Qlik,

I need this calculation in a Percentage Column as 'Net Profit %' how to achieve this. thanks

= sum(revenue) - sum(burdened_cost)
/
sum(revenue)

1 Solution

Accepted Solutions
Employee

Aren't you simply looking for this expression?

``(Sum(revenue)-Sum(cost))/Sum(revenue)``

If it's how to format the fraction as a percentage you are really asking for, then you do that in the measure properties. Click on "Number formatting", choose "Number" in the drop-down menu, then choose a percentage formatting of your choice in the "Simple" drop-down menu.

5 Replies
Employee

I'm not sure how your burdened_cost value relates to the revenue for each table row compared to the total revenue, but typically a percentage of the total would be calculated like this:

``Sum(Sales)/Sum(total Sales)``

Here's a similar thread on the topic:

https://community.qlik.com/t5/App-Development/Calculating-percentage-of-total-by-dimension/td-p/1198...

Specialist II

What is your qlik related question?  How to format in percent or what your calculation should be?

Creator III
Author

Hi,

My profit column should be like sum(revenue)-sum(cost) divided by Sum(revenue).

I need this expression should be as profit % coloum.

Hope you are clear.

First I want to minus two values and then divided by revenue.

thanks for you help!

Employee

Aren't you simply looking for this expression?

``(Sum(revenue)-Sum(cost))/Sum(revenue)``

If it's how to format the fraction as a percentage you are really asking for, then you do that in the measure properties. Click on "Number formatting", choose "Number" in the drop-down menu, then choose a percentage formatting of your choice in the "Simple" drop-down menu.

Creator III
Author

Yes! thanks you 🙂