Text 679, 56 rader
Skriven 2004-09-24 11:42:38 av Gary Britt (1:379/45)
    Kommentar till text 675 av Ellen K (1:379/45)
Ärende: Re: need algorithm
==========================
From: "Gary Britt" <garyb@nospamforme.com>

Ellen, can you tell me the purpose of the table you are trying to build. Are
you trying to just have a lookup table that validates if information entered is
within an acceptable range?  In other words can you describe what is the basic
transaction for which this table you are constructing will be used?

Thanks,

Gary

"Ellen K" <Ellen.K@harborwebs.com> wrote in message
news:908654.36bcab@harborwebs.com...
> I need a mathematical algorithm as follows:
>
> For the risk dimension of my data warehouse I need one row for every
possible
> combination of down payment amount, down payment percentage, and term in
> months.   I created a working table by means of a Cartesian product.
Then I
> deleted all the rows where down payment was 0 but down payment percentage
was
> not 0, and also deleted all the rows where down payment percentage was 0
but
> down payment dollars was not 0.   I still have close to 13 million rows
and
> would just as soon reduce the size further by removing rows representing
other
> impossible combinations... so I need an algorithm for defining the
impossible
> combinations.  For example, if $5000 is the highest sales price for a
single
> transaction, then $5000 can't be, say, a 1% down payment.   Note that
there is
> an additional complication in that down payment percentage is calculated
> against the sales price, not against the total transaction, which is
comprised
> of sales price + shipping + interest + sometimes sales tax, so that a
$1000
> sales price might be an $1100 total transaction... in which case a $200
down
> payment would be considered to be 20%, and if they pay cash, their "down
> payment" is 110%.
>
> So far I think I see that "impossible" only applies to the higher dollar
down
> payments, IOW a $100 "down payment" could theoretically be 100% of a $100
sale.
>  It seems like the algorithm must be some kind of percentage calculation
of
> down payment amount vs the maximum sales price...  ?
>
> Any light anyone can shed will be greatly appreciated.   :)

--- BBBS/NT v4.01 Flag-5
 * Origin: Barktopia BBS Site http://HarborWebs.com:8081 (1:379/45)