By using this website, you agree to our Terms of Use (click here)
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)
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)
Yes indeed Tim,
What I ended up doing was assigning the following formula to the variable $Cases =$Cases+IIf([SOShipLine.OrderUOM]<>[InventoryItem.BaseUnit] , [SOShipLine.Qty],0) and the corresponding formula for the variable $Units. It worked like a charm! Thanks!
Online Members
