Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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.
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:
What is your qlik related question? How to format in percent or what your calculation should be?
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!
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.
Yes! thanks you 🙂