RE: Formula Question

Mike,
Mike,
        Here is a formula I got to work...
((((period-12)/(period-12*.0000001)) *period) - 11)+period

The ".0000001" is a little trick to prevent divide by zero but not
produce any real number to influence the whole number result.  Try it
out in STRSQL over your file.


Now if you are using in SQL, cast the formula as a DEC(2,0) or in RPG
EVAL into a field with no decimal positions with %INT() or %DEC(2,0)
(the RPG portion not actually test by me).


Thank you,
Matt Tyler
WinCo Foods, LLC
mattt@xxxxxxxxxxxxxx


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Wills
Sent: Wednesday, January 04, 2006 4: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