About using one compute statement to produce reports for multiple companies

Note: @CUCP only works with total names and does not work with a Style 2 report.

Using the data dictionary item @CUCP with total names, you can use one compute statement to produce reports for multiple companies. You can do this by defining a company range and selecting the company level for individual reporting options. @CUCP individually calculates a result for each company in the range. The companies must have the same organizational structure (that is, same number of levels and size of levels). You must define the total names first before defining the compute statement.

Example

LGE wants to calculate and report on the current period gross profit percentage. They define the total names GROSS and SALES to use in the compute statement. Then, they define this compute statement:

(CPTOT(GROSS, @CUCP)/CPTOT(SALES,@CUCP))*100

On the Additional Parameters form for either a Style 1 or Style 3 report, they define the company range. Then, they select the company level for individual reporting options on the Level Range form. This will produce multiple individual reports for each company in the range using the same compute statement as previously defined.