Percentage Calcualtion.

[MuraliPrasath]

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)

[Øystein_Kolsrud]

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...

[stevejoyce]

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

[MuraliPrasath]

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!

[Øystein_Kolsrud · Accepted solution]

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.

[MuraliPrasath]

Yes! thanks you 🙂