Example

LGE has created a compute statement to calculate a year-to-date gross profit percentage. This is the calculation for gross profit percentage:

(YTD Gross Profit Dollars / YTD Net Sales) * 100

Total names

Before defining the compute statement, they defined two total names that they would need to use in the computation:

  • GROSS: This represents gross profit dollars and is used in the numerator of the compute statement.

  • SALES: This represents net sales and is used in the denominator of the compute statement.

Compute statement

Using the two total names, LGE created a compute statement named GRSPROFIT. They patterned the compute statement after the calculation for gross profit percentage.

Illustration: using a compute statement with a ratio

Ratio

To view the results of the compute statement online, LGE defined a ratio and assigned the compute statement to the ratio. Using the Ratio Analysis subform, they can now view the results of the compute statement without having to include it in a report and generate the report.