I'm trying to create a chart based on a series of data entered. I need it so
the data is entered into a series of fields, then those fields are put
through a calculation. If the calculation is over say 1000, another
calculation is used to determine the x,y of a scatter graph and it is under
1000 a seperate calulation is used to deterimine x,y. Is that possible? I've
been messing around for a while but cant get it to work. I tried creating an
SQL function but it didn't work. Any help would be wonderful. Thanks!