Forum

How to find profit ...
 
Share:
Notifications
Clear all

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

2 Posts
2 Users
0 Likes
336 Views
KV Kumar
Posts: 27
Admin
Topic starter
(@vinodkrsetty)
Eminent Member
Joined: 3 years ago

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

1 Reply
Naveen
Posts: 36
 Naveen
Guest
(@Naveen)
Eminent Member
Joined: 2 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 
Reply

Leave a reply

Author Name

Author Email

Title *

 
Preview 0 Revisions Saved
Share: