FIX: CALCULATE SUM() on Currency Field Gives Illegal Operation

   SET TALK OFF
   CREATE TABLE junk (amt y)
   INSERT INTO junk (amt) VALUE(1.00)
   INSERT INTO junk (amt) VALUE(0.20)
   CALCULATE SUM(amt) TO mx
   mx=STR(mx)  && Converts the value from numeric to character type.
   mz = (VAL(mx) < 0)  && Converts mx back to numeric data type.
   ? mz
				

MORE INFORMATION

The following code illustrates this behavior. The use of other aggregate functions, such as AVG(), in the CALCULATE function produces similar results.

Steps to Reproduce Behavior

Enter the following code in a program and execute:

   SET TALK OFF
   CREATE TABLE junk (amt y)
   INSERT INTO junk (amt) VALUE(1.00)
   INSERT INTO junk (amt) VALUE(0.20)
   CALCULATE SUM(amt) TO mx
   mz = (mx < 0)
   ? mz
				

The error occurs during the comparison of the variable created with the CALCULATE SUM() function and another value. In the example above, initially declaring the variable mx numeric does not prevent the error.