Rounding up to increments

[FMDuck]

I hate to say it but I think I asked this one before but can't find my post or where I used it

I have an inventory solution where I need to round up from selling units to an increment of buying units. For example:

Paint Cans

sellingUnit is by the can (1 each)

buyingUnit is by the case (1 case) = 12 each

buyingQuantity is by the pallet (105 cases) = 1260 each

So:

when I need 1 each, I need to purchase 105 cases

when I need 1261 each, I need to purchase 210 cases, etc.

Thanks in advance for any help.

[comment]

Sounds familiar - did you perhaps mean this one:

http://www.fmforums.com/forum/showtopic.php?tid/191810/

[FMDuck]

Thanks Comment - that was it.

(It looks like I used my wifes login ? for the original post ?)

For the record, the needs had changed since then. Here's my resulting calc:

Let( [ 

   basisA =

      Case(

         INVSTOCK::cQtyIsSufficient4Purchase ;

         ( INVSTOCK::MinimumStock +

         INVSTOCK::cQtyToPurchase4Customer ) / INVSTOCK::ConversionFactor

      )

 ;

   basisB =

      Ceiling ( basisA / INVSTOCK::MinimumBuy )

] ;



basisB * MinimumBuy



)