RE: Formula Question

Surely (period-12)/(period-12) is ALWAYS = 1 ?!?
Therefore rendering: ((((period-12)/(period-12))*12)-11)+period
                   = (((1*12))-11)+period
                   = ((1)+period 
                   = ((1)+period 

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Wills
Sent: Thursday, 5 January 2006 10:32 AM
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