Report Designer: Separate Sum by Total Cases and Total Units in Picking Slip
Hi to all,
I was wondering if there's a way of creating a variable for separating cases amount and single units amount. I am attaching a picture to explain myself better.
In this example, I have 1 case, and 18 single units of different items. But the totals the report bring up are 22 pieces (18 single units, plus the 4 units inside the case) and 19 cartons (the case plus the 18 single units). Is there a way of separating the sum depending on the UOM in the original order? I tried 'IIf(([SOShipLine.OrderUOM]<>'CASE'),'0',sum([SOShipLine.Qty]))' and also tried IIf(([SOShipLine.OrderUOM]='CASE'), sum([SOShipLine.Qty]), '0') but none of them work. I do not know a way of configuring a variable to get the expected results. Thanks in advance for your help!
Does it work if you remove the single quotes from around your zeros like this?
IIf(([SOShipLine.OrderUOM]<>'CASE'),0,sum([SOShipLine.Qty])) IIf(([SOShipLine.OrderUOM]='CASE'), sum([SOShipLine.Qty]), 0)