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.
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.