how to calculate the net profit i have cost price and sales price

[Hassan_Tanna]

how to calculate the net profit i have cost price and sales price in product table !  i have cost price in the product table only and i want make a chart or table to show me the net profit of total orders !

product tableproduct table

[Joseph_Seddik · Accepted solution]

According to your tables, what you need to do in order to calculate profit per order is to subtract the relevant products cost + shipping fees from the total value of the order that you name it "Total Cost". 

To do this you can do the following:

1. In your OrderDetails table add a new column "Product Cost". Its formula should be: 
   
   [Product ID].[Cost Price]
   
   
2. The total products cost for your order in Orders table will be: 
   
   SUM([Related OrderDetails][Product Cost])
   
   
3. The total shipping fees for your order in Orders table will be: 
   
   SUM([Related OrderDetails][shipping fees])
   
   
4. Thus, the total profit for your order will be: 
   
   [Total Cost] 
   - SUM([Related OrderDetails][Product Cost])
   - SUM([Related OrderDetails][shipping fees])
   
   

I noticed that you add the shipping fees to only one item per order in your OrderDetails table. This indicates that you are collecting a shipping fee per order not per item, which is the expected usual practice. Hence, it is better to remove the shipping fee column from the OrderDetails table and add it instead to the Orders table. In this case, the expression should be:

[Total Cost] - [shipping fees]
- SUM([Related OrderDetails][Product Cost])

Read these:

Dereference Expressions | AppSheet Help Center 
List Dereference | AppSheet Help Center 

[Joseph_Seddik · Accepted solution]

Order date?

and instead of the “…” you should complete the list of months