Load correct sale

Hauglaen — Sun, 22 Sep 2019 10:59:41 GMT

Hi,

I have a problem with incorrect copies sold on transaction level when there are more than one seller on the sale.

Example:

The above example should look like this:

Is it possible to solve this in Date load editor?

Re: Load correct sale

Anil_Babu_Samineni — Sun, 22 Sep 2019 11:20:56 GMT

Perhaps this?

Load distinct [Transaction number], [Copies sold], Sum(Provision) as Provision Resident Table Group By [Transaction number], [Copies sold];