Greetings. I am creating a formula for an order report so that the items will display as whole cases and partial cases. For example, if there are 12 to the case but a customer orders 13, it displays as 12 cs and 1 p.

Current Formula which does not work:
totext (Truncate ({OrderDetailLot.Quantity}/{Product.AlternateUnitConversionFactor}),0)
& "cs" & Space(3) & "/" &
If Remainder ({OrderDetail.QtyOrdered},{Product.AlternateUnitConversionFactor})>0 then totext (Remainder({OrderDetail.QtyOrdered},{Product.AlternateUnitConversionFactor}),0)
& "p" & Space(3)& "/" & {OrderDetailLot.LotNumber} else {OrderDetailLot.LotNumber}

I was told to use:
right (cstr({@your formula for qty/converstionfactor}),3)
but have no idea how to do so as playing around with it produced no results.

Also, the items have lot numbers. A particular shipment can come from 2 lots so it is important to have the lots show up next to the results (as you can see via the formula).

Help!