Calculate margin percentage

[#1]

Hello, I am new to qlikview and have a very basic tool question that can't seem to figure out.

The question is, how do I add "margin percentage" in my bar chart? I have the margin by total amount but I can't seem to add the percentage.

I tried the following expression : "sum ((total sales/cost) * 100) but it doesnt work. Please help!!

[#2]

Hi,

try sum(total sales) / sum(costs). Take a look at the checkbox 'Show in Percent' on the numbers tab.

[#3]

Thank you so much! It worked!

[#4]

Hi KaliPres,

would you mark this thread as solved. Thanks, Roland