Updating Calculated Fields (Functions/Subroutines/Programs)

In order to have a calculated field update information on the fly when entering in data into and edit table, you have to add code to the calculated field in the table builder.  The following code example shows how to do this.  The code is also based on two(2) numeric fields, both multi-valued,  (QTY & PRICE) updating the calculated field (COUNT), also multi-valued.

@ANS = ""

QTY = {QTY} <1,@mv>

PRICE = {PRICE} <1,@mv>

COUNT = COUNT(QTY, @vm) + (QTY # "")

for i = 1 to COUNT

      IF len(QTY<1,i>) and  len(PRICE<1,i>) and  num(QTY<1,i>) and num(PRICE<1,i>) THEN

            @ANS<1,i> = (QTY<1,i>) * (PRICE<1,i>)

      END

next i