Mathimatical functions

[Bill]

I'm a little stumped on how to accomplish this.

Here is what I have

**************

<cfif rsGetCart.cart_sku_qty lte 2>
<cfset Client.CartSubTotal = Client.CartSubTotal +
(rsGetCart.SKU_Price*rsGetCart.cart_sku_qty)>
<cfelse>
<cfset Client.CartSubTotal = Client.CartSubTotal +
(rsGetCart.SKU_Price*(rsGetCart.cart_sku_qty - int(rsGetCart.cart_sku_qty /
3)))>
</cfif>

**************

<td align="right">
<cfif rsGetCart.cart_sku_qty lte 2>
#LSCurrencyFormat(rsGetCart.SKU_Price*rsGetCart.ca rt_sku_qty,'local')#
<cfelse>
LSCurrencyFormat(rsGetCart.SKU_Price*rsGetCart.car t_sku_qty,'local')#<br />
</cfif>

***************8

And I need it to do this

For instance:
If I order 2 I get 1 more free = 3 total

If I order 3 I still get 1 free = 3 total

order 4 I get 2 free = 4 total

order 6 I get 3 free = 6 total

order 7 I still get 3 free = 7 total

and so on...

So it only updates the free quantity when its an even number.

The code I have works for adding 1 if the quantity is greater then 2 but to
get it to add 2 if the quantity is 4 and 3 if the quantity is 6 is what has
me stumped.

Any knowledgeable folks out there that can offer the code to point me in the
right direction??

Bill

[Bill]

Sorry wrong snippet. Tis post is revised

I'm a little stumped on how to accomplish this.

Here is what I have

**************

<cfif rsGetCart.cart_sku_qty lte 2>
<cfset Client.CartSubTotal = Client.CartSubTotal +
(rsGetCart.SKU_Price*rsGetCart.cart_sku_qty)>
<cfelse>
<cfset Client.CartSubTotal = Client.CartSubTotal +
(rsGetCart.SKU_Price*(rsGetCart.cart_sku_qty - int(rsGetCart.cart_sku_qty /
3)))>
</cfif>

**************

td align="right">
<cfif rsGetCart.cart_sku_qty lte 2>
#LSCurrencyFormat(rsGetCart.SKU_Price*rsGetCart.ca rt_sku_qty,'local')#
<cfelse>
#LSCurrencyFormat(rsGetCart.SKU_Price*(rsGetCart.c art_sku_qty -
int(rsGetCart.cart_sku_qty / 3)),'local')#
</cfif>


***************8

And I need it to do this

For instance:
If I order 2 I get 1 more free = 3 total

If I order 3 I still get 1 free = 3 total

order 4 I get 2 free = 4 total

order 6 I get 3 free = 6 total

order 7 I still get 3 free = 7 total

and so on...

So it only updates the free quantity when its an even number.

The code I have works for adding 1 if the quantity is greater then 2 but to
get it to add 2 if the quantity is 4 and 3 if the quantity is 6 is what has
me stumped.

Any knowledgeable folks out there that can offer the code to point me in
the
right direction??

Bill

[mxstu]

Something like this maybe..



<cfoutput>
<cfloop from="1" to="20" index="qty">
<cfif qty gte 2>
<cfset qtyFree = Int(qty / 2)>
Qty #qty# + Free #qtyFree#<br>
</cfif>
</cfloop>
</cfoutput>

[Bill]

Thank you.

I'm gonna try it right now

Bill


"mxstu" <webforumsuser@macromedia.com> wrote in message
news:d8pa4m$err$1@forums.macromedia.com...

> Something like this maybe..
>
>
>
> <cfoutput>
> <cfloop from="1" to="20" index="qty">
> <cfif qty gte 2>
> <cfset qtyFree = Int(qty / 2)>
> Qty #qty# + Free #qtyFree#<br>
> </cfif>
> </cfloop>
> </cfoutput>
>

[parvee]

Try following, after you separate original and free you can easily calculate
the price. Hope this helps

<cfif Mod(rsGetCart.cart_sku_qty/2) EQ 0>
<cfset chargable_order=rsGetCart.cart_sku_qty>
<cfset free_order=rsGetCart.cart_sku_qty/2>
<cfelse>
<cfset
chargable_order=rsGetCart.cart_sku_qty-int(rsGetCart.cart_sku_qty/2)>
<cfset free_order=int(rsGetCart.cart_sku_qty/2)>
</cfif>

**************

[Bill]

That is awesome. Thank you parvee

Bill


"parvee" <webforumsuser@macromedia.com> wrote in message
news:d8q6re$oe9$1@forums.macromedia.com...

> Try following, after you separate original and free you can easily
> calculate
> the price. Hope this helps
>
> <cfif Mod(rsGetCart.cart_sku_qty/2) EQ 0>
> <cfset chargable_order=rsGetCart.cart_sku_qty>
> <cfset free_order=rsGetCart.cart_sku_qty/2>
> <cfelse>
> <cfset
> chargable_order=rsGetCart.cart_sku_qty-int(rsGetCart.cart_sku_qty/2)>
> <cfset free_order=int(rsGetCart.cart_sku_qty/2)>
> </cfif>
>
> **************
>
>
>

[Bill]

Hi Parvee

What is MOD referring to??

Bill
"parvee" <webforumsuser@macromedia.com> wrote in message
news:d8q6re$oe9$1@forums.macromedia.com...

> Try following, after you separate original and free you can easily
> calculate
> the price. Hope this helps
>
> <cfif Mod(rsGetCart.cart_sku_qty/2) EQ 0>
> <cfset chargable_order=rsGetCart.cart_sku_qty>
> <cfset free_order=rsGetCart.cart_sku_qty/2>
> <cfelse>
> <cfset
> chargable_order=rsGetCart.cart_sku_qty-int(rsGetCart.cart_sku_qty/2)>
> <cfset free_order=int(rsGetCart.cart_sku_qty/2)>
> </cfif>
>
> **************
>
>
>

[parvee]

Sorry, I am wrong, you need use mod like below
(rsGetCart.cart_sku_qty MOD 2) EQ 0

MOD is a coldfusion operator.