How to calculate Net Sales

PrevisionzGmbH
Visitor
1 0 0

Hello everyone,

 

I am using the Alpha Serve Power BI Connector to build up a Power BI report for the owners of this shopify account. Everything works pretty well, but I can't figure out which field I have to use to calculate the net sales. Shopify offers various fields to calculate the sales amount, but none of them matches 100% with the sales over time statistic shopify offers.

What is used there?

I found out that „presentmentMoneyAmount“ from the table „orders_originalTotalPriceSet“ fits really good, but it is not filled for every month.

 

I hope one of you knows the solution for this problem. Thank you and happy holidays.

 

Greetings

Replies 0 (0)