percent increase from previous - Pacific Knowledge Systems

percent increase from previous calculates the percent increase from the previous 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          2.2          2.0          2.3
LDL                        6.2          4.7                       3.1
Trig          3.6                                    3.6
LipidDrug     N                         Y            Y

percent increase from previous HDL is 15

percent increase from previous LDL where LDL is numeric < -33

percent increase from previous HDL where LipidDrug is “Y” > -10