Thanks for the tips, Ben...
> -Original Message-
> From: Ben Doom [mailto:[EMAIL PROTECTED]
> Sent: Thursday, November 01, 2007 2:42 PM
> To: CF-Talk
> Subject: Re: How to break down a number into percentages
>
> Without seeing your code, I can say this with a fair
Thanks for the tips and guidance, Jochem...
Rick
> -Original Message-
> From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
> Sent: Thursday, November 01, 2007 4:18 PM
> To: CF-Talk
> Subject: Re: How to break down a number into percentages
>
> Rick Faircloth wrote:
Rick Faircloth wrote:
>
> 1. dB column is defined as "decimal(10,2)NOT NULL"
> update accounts
> set balance = value="#LSParseNumber(current_balance)#">
> where account_id = '#get_accounts.account_id#'
>
> Would this cause the "balance" column variable to come
> an in
Without seeing your code, I can say this with a fair degree of
certainty: if you're really losing 3%, you are probably doing something
wrong (like always truncating, using integers instead of floats, etc.).
If you round to the nearest cent, you should be getting totals like
$99.97 or $100.02 w
f calculations, but I still haven't found where I'm going wrong.
Rick
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Thursday, November 01, 2007 12:58 PM
> To: CF-Talk
> Subject: Re: How to break down a number into percentages
>
Hi, Greg... see my response to Williams for the code...
Rick
> -Original Message-
> From: Greg Morphis [mailto:[EMAIL PROTECTED]
> Sent: Thursday, November 01, 2007 1:14 PM
> To: CF-Talk
> Subject: Re: How to break down a number into percentages
>
> Can you provide
Can you provide the code you're using to store those numbers?... if
the data type is correct, then maybe it's how it's breaking the number
down and storing it in the DB that needs some work.
On Nov 1, 2007 11:39 AM, Rick Faircloth <[EMAIL PROTECTED]> wrote:
> Hi, all.
>
> I know that sounds simple
can find the issue?
William
-Original Message
-From: [EMAIL PROTECTED]
-Date: Nov 1, 2007 8:39
-To: "CF-Talk"
-Subj: How to break down a number into percentages
-
-Hi, all.
-
-I know that sounds simple and, as it's stated, it is.
-
-However, what I'm trying to accomplis
Hi, all.
I know that sounds simple and, as it's stated, it is.
However, what I'm trying to accomplish turns out to be more
complicated that I thought.
I want to take a dollar amount, break it down by various percentages
(that should total 100%), then place the dollar amounts into various
account
9 matches
Mail list logo