calculate two column

[#1]

dears,

i want to calculate two column to get the total sales. i have two column one for price and other one for the cost . i want to get the gross and net profit from this two column.

regards

Abdullahkn

[#2]

Hi Adbullah,

Create one more expression as "Gross Sales" = Sum(Price)

One more expression as "Profit" = sum(Price)-Sum(Cost)

Regards

Rajesh

[#3]

hi Rajesh

i made two expression as you said but i got the total of price and total of cost i want to merge it to be one answer

thanks

Abdalla

[#4]

Hi Abdulla,

Pls share the application so that it will easier to look into it.

You can also add Sum(Price) + Sum(Cost) or Sum(Price + Cost) if you want.

Regards

Rajesh

[#5]

Rajesh,

in the expression i did like this but still not calculate the gross profit

please tell me how to do this .

Sum(Price) + Sum(Product-Cost)

Abdalla,

[#6]

Hi,

Pls share the application with dummy data.

Regards

Rajesh

[#7]

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/1122.Book1.xls:550:0]

[#8 · Accepted solution]

Hi Adbulla,

Pls find the attached application for your refer.

Regards

Rajesh

[#9]

Hello Abdullahkn,

Please find attached a file for your reference. Hope i understood your question.

Regards,

Ankur