percent increase from min - Pacific Knowledge Systems

percent increase from min calculates the percent increase from the minimum value to the current value. For example, given the following case fragment:

           01 Jun 03    20 Jun 03    30 Jun 03    15 Oct 03    02 Nov 03
HDL           2.0          2.1          1.2          2.0          2.4
LDL                        6.2          4.7                       3.1
Trig          3.6                                    3.6
LipidDrug     N                         Y            Y

percent increase from min HDL is 100

percent increase from min LDL is 0

percent increase from min Trig where Trig is numeric is 0