Hello, I'm trying to develop a report which shows the profit margin for customers. I was going to use (Total Sales - Total Cost) / Total Sales. Does anyone know if there is a 'Total Cost' field? All I can get is the cost for each item on the transaction...which will work but I'll have to do a bunch of grouping/sub-totaling. Even a total cost for transaction would work. Suggestions?
Thank you.
Hello, I'm trying to develop a report which shows the profit margin for customers. I was going to use (Total Sales - Total Cost) / Total Sales. Does anyone know if there is a 'Total Cost' field? All I can get is the cost for each item on the transaction...which will work but I'll have to do a bunch of grouping/sub-totaling. Even a total cost for transaction would work. Suggestions?
Thank you.
Have something to add? Share your thoughts — no account required.
Ask the community — no account required