You need the TOTAL function to keep the running totals, and the CALC keyword to use them in the formula. CALC EVAL "TOTAL(IF FIELDZ = X THEN COUNTER ELSE 0) * FIELD1 / TOTAL(1)" ----- Original Message ----- From: Kevin Michaelsen <[EMAIL PROTECTED]> Date: Fri, 05 Mar 2004 14:55:33 -0500 To: [EMAIL PROTECTED] Subject: multiplying totals
> I need help on the syntax when multiplying with an EVAL statement. I've > tried simplify the statement. It goes something like this: > AVERAGE FIELD1 * TOTAL EVAL "IF(FIELDZ=X )THEN COUNTER ELSE 0" > > I basically want the average of FIELD1 (MULTIPLIED) BY COUNTER > > Any help would be appreciated. > > kevin > > -- > u2-users mailing list > [EMAIL PROTECTED] > http://www.oliver.com/mailman/listinfo/u2-users > -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users