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
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
You count the full cases first,multiply by case price, then add the
value associated with the remainder.
Sent from my iPhone
On Oct 17, 2008, at 8:17, WebDude [EMAIL PROTECTED] wrote:
Having a hard time wrapping my head around this one. Any help would
be appreciated.
Let's say we have
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 think you have to do this:
@ASSIGN q @CALC 'floor(@ARG QTY / 12)'
Brian Humes
Director, Interactive
JohnsonRauhoff
269-428-9257 (direct)
269-428-3377 (main)
269-428-3312 (fax)
www.johnson-rauhoff.com
[EMAIL PROTECTED]
On Oct 17, 2008, at 10:50 AM, WebDude wrote:
Sorry if I am dense,
Okay, I got it working halfway using this...
@ASSIGN r @CALC EXPR='@ARG quantity%12'
@ASSIGN q @CALC EXPR='@ARG quantity/12' PRECISION=0
@CALC EXPR=(@VAR q * 26)+(@COLUMN 'shippingprice.price')
PRECISION=2
It calculates correctly until you try any of the following quantities...
6 through
Thanks everyone for your help... I got it working...
@ASSIGN q '@CALC EXPR=floor(@ARG quantity/12) PRECISION=0'
@ASSIGN r '@CALC EXPR=@ARG quantity%12'
@CALC EXPR=(@VAR q * 26)+(@COLUMN 'shippingprice.price')
PRECISION=2
Still silence from down under.
Rich
-Original Message-
From: John Carrieri [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2008 7:01 PM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Witango 6 update (please)
Yes, Please give us info.
I just had to make a decision to