Sorry if I am dense, Beverly, but I am not able to get this to work. It kind of half works.
Here is what I am doing... <@ASSIGN r "<@CALC '<@ARG QTY> % 12'>"> <@ASSIGN q "<@CALC '<@ARG QTY> / 12'>"> <@CALC "(<@VAR q> * 26.00) + ( This is a search for <@VAR r> which returns the <@COLUMN shipcost.price> )"> Now, if I plug in the number 1 (quantity 1) This would look like this... R = 1 Q = 0.0833333333333333 Thus I get... 0.0833333333333333 * 26.00 + (14.50) = 16.6666666666667 Answer should be 14.50 And if plug in the number 13 (quantity 13) I get... R = 1 Q = 1.08333333333333 Thus I get... 1.08333333333333 * 26.00 + (14.50) = 42.6666666666666 Answer should be 40.50 John Muldoon Corporate Incentives 3416 Nicollet Ave S Minneapolis, MN 55408-4552 612.822.2222 [EMAIL PROTECTED] http://cipromo.com -----Original Message----- From: Beverly Voth [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2008 8:47 AM To: [email protected] Subject: Re: Witango-Talk: One for the Math Gurus Use the MODULO function to get the remainder. r = QTY % 12 Along with the quotient. q = QTY / 12 (q * 26.00) + ( {lookup what the price is for "r" items} ) Beverly On 10/17/08 9:17 AM, "WebDude" <[EMAIL PROTECTED]> wrote in whole or in part: > Having a hard time wrapping my head around this one. Any help would be > appreciated. > > Let's say we have bottles of perfume for sale. For shipping, we can > fit 12 bottles into a box. Each box is sent separately via a courrier. > The courrier charges x amount for each box plus weight. To make a long > story shorter, in this scenario, we have different charges for > quantities of bottles within a box. So, for a specific zone, we charge like so... > > Quantity Price > 1 $14.50 > 2 $15.50 > 3 $16.50 > 4 $18.50 > 5 $18.75 > 6 $19.00 > 7 $20.00 > 8 $21.00 > 9 $22.00 > 10 $23.00 > 11 $25.00 > 12 $26.00 > > Now the problem is the thirteenth bottle. We need to charge 26.00 + 14.50. > 14th bottle would be 26.00 + 15.50. > 15th bottle would be 26.00 + 16.50, etc. > And to continue following this format... > 24 bottles would be 26.00 + 26.00 > 25 bottles would be 26.00 + 26.00 + 14.50 > 26 bottles would be 26.00 + 26.00 + 15.50 > 27 bottles would be 26.00 + 26.00 + 16.50, etc. > > There is a formula in there somehow, but I am having a devil of a time > trying to figure it out. Any help would be appreciated. > > Thanks! > > > ______________________________________________________________________ > __ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
