Group By - Sum is not what is expected

Options
Luongp
Luongp Registered Posts: 1

I have imported a dataset from excel and there are 190k rows of data with each row representing a shipment that is made. A shipment will have an associated customer number, revenue, and cost. I imported my data and made sure my aggregation columns are in integer type.

When I use the group by recipe and select customer number as the group key and the revenue and cost as the sum aggregate, the outputted dataset's sum of the revenue and cost are very off than what they would be if I manually calculated it on excel. I see that the count of the rows are the same for the customer number when I compare them to my dataset from excel but somewhere I am losing my cost and revenue numbers when it aggregates the sum.

Answers

Setup Info
    Tags
      Help me…