Re: Formula Question

Aw crap... Here is the formula (I swear I am dyslexic).

=((((12-A1)/(12-A1))*12)-11)+A1

A1 = period or month. Matt's suggestion works.

On 1/4/06, DeLong, Eric <EDeLong@xxxxxxxxxxxxxxx> wrote:
>
> Mike,
>
> I'm afraid I'm not seeing what you're trying to do....  Perhaps I'm a bit
> rusty at algebra, but to me this formula does not seem to do anything....
>
> ( ( ( (period-12) / (period-12) ) * 12 ) - 11 ) + period =
> ( ( (  1                        ) * 12 ) - 11 ) + period =
> ( (    12                              ) - 11 ) + period =
> (      1                                      ) + period
>
> Huh?
>
>
> Eric DeLong
> Sally Beauty Company
> MIS-Project Manager (BSG)
> 940-297-2863 or ext. 1863
>
>
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Mike Wills
> Sent: Wednesday, January 04, 2006 5:32 PM
> To: RPG programming on the AS400 / iSeries
> Subject: Formula Question
>
>
> Okay, this may be a difficult one. I have a simple table layout like this.
>
> Company (4,0)
> Year(4,0)
> Period(2,0)
> Amount(15,2)
>
> I want to be able to take an ending period and determine 12 months back
> from
> the ending date and select records in the DB via a select statement. We
> are
> really close with the following formula: ( ( ( (period-12) / (period-12) )
> *
> 12 ) - 11 )+period. A co-worker of mine got this far. If it wasn't for the
> whole divide by zero bit as this portion ( (period-12)/(period-12) ) would
> for period 12, it would work great. Short of a case statement is there a
> better way to handle divide by zero? Or is the a better formula that we
> aren't seeing?
>
> --
> Mike Wills
> koldark@xxxxxxxxx
> http://mikewills.name
> Want Gmail? Email koldark+gmail@xxxxxxxxx to get on my waiting list.
>
> "There are 10 types of people in the world: those who understand binary,
> and
> those who don't." -Unknown
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>


--
Mike Wills
koldark@xxxxxxxxx
http://mikewills.name
Want Gmail? Email koldark+gmail@xxxxxxxxx to get on my waiting list.

"There are 10 types of people in the world: those who understand binary, and
those who don't." -Unknown