Rounding not correct in ALL
Do you know why I'm getting wrong value on Total Containers for ALL for Inbound Pallets (see image)?
For example: W/c 18th Jan 21 should be 4 and not 3. I suppose the 3 is based on 1.159 + 1.159 = 2.318 so rounds to 3. But I want it to be based on the already rounded 2 value.
I can't use SUM in the Total Containers line item because that will SUM all individual rows and I get 12 containers (there are 6 products for each shipper and it rounds every one up to a container).