Discussions
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Join us
Analytics - Customer Profitability Report
I am trying to create a custom customer profitability report in Analytics.
We have some custom fields and columns on an invoice & invoice line that calculate the values for warehousing / delivery and another that calculates the rebate percentage per item for that customer.
I'm trying to build a dataset that will give me the cogs from the item fulfilment and the revenue from the invoices or credit memos.
Where I am struggling is to calculate the COGs from an item fulfilment in it's own column. When I grab QTY x Transaction line Rate this gives me the values for the item fulfilment as COGs but because I need revenue in it's own column this way isn't working as in an analytics report it is bundling the rate x QTY values from the item fulfilment in with the invoices value.