How would I write...? HELP!

I am working with a Cytogenetics group doing chromosome studies/research and they have a need for controls (control data). One of their tables might look like...

signal_1 signal_2 signal_3 signal_4 signal_1_pct signal_2_pct ..etc..
-------- -------- -------- -------- ------------ ------------

  12         78       10         0            12%           78%
   5         75       18         2            8.5%         76.5%
   6         84       10         0           7.76%          79%

I need to SUM each signal and divide by the total cell count for each record to get the percentage for each signal.

I know that I can/might be able to do this within the SQL*Forms at the time each record is commited to the database (the researcher decides which of the data records will be added to the control set).

Anyone have a clue as to how I might process this information? Using the SUM feature groups data and I want to process one record at a time but be able get the TOTAL cell count and the TOTAL SIGNAL_n count too.

That's in advance for your help...

-Mike
Received on Wed Jun 19 1996 - 00:00:00 CEST