Use numeric variables to calculate values based on other values in the database.
For example, to calculate employee compensation if the total compensation includes employee salary plus an employee commission, you could create a numeric variable to add the salary and commission fields as follows:
$SAL + $COMM
Look at the example, "correlate_subquery.srm" given in the Samples folder for a better understanding of numeric variables. In this example, the numeric variable is "ExceedsAverageSalaryBy", and represents the difference between the employee's salary and the average salary for the region.
The following is the default path for the Samples folder and example: C:\Hyperion\products\biplus\bin\SQR\Studio\samples\correlated_subquery.srm If you placed SQR Production Reporting Studio in a destination other than the default destination, then look for the Samples folder there.