How to find profit percent from sale amount & purchase amount?

Last Post

RSS

Posts: 27

KV Kumar

Admin

Topic starter

Jul 27, 2020 12:03 pm

(@vinodkrsetty)

Eminent Member

Joined: 5 years ago

Please answer to this question How to find profit% from sale amount & purchase amount?

This topic was modified 3 years ago by KV Kumar

Topic Tags

1 Reply

Posts: 36

Naveen

Guest

Jul 30, 2020 7:00 am

(@Naveen)

Eminent Member

Joined: 4 years ago

Hi,

You can try the below queries. I have chosen Sales_Table here.

Select Country, (Sum(Profit)*100/Select Sum(Sales) from Sales_Table)) as Per_Profit from Sales_Table
Group By Country

Select Country, (Sum(Purchase)*100/Select Sum(Sales) from Sales_Table)) as Per_Purchase from Sales_Table
Group By Country

This post was modified 3 years ago by KV Kumar