@PERCENT_SERIES (Create Ratio Series)

This macro can be used to change the values of an existing series in a chart to show the ratio of two other series. The value of the ratio series (at nTarget) is calculated by dividing the value of series nTop by the value of the series at nBottom. Note that the target series (nTarget) must already exist in the chart.

SYNTAX:

@PERCENT_SERIES nTop nBottom nTarget

PARAMETERS:

nTop; 1...n (where: n = the total number of series in the chart) selects the first source series.

nBottom; 1...n (where: n = the total number of series in the chart) selects the second source series.

nTarget; 1...n selects the target series. It must be a series that currently exists in the chart.

EXAMPLE:

@AGL 0 Los Angeles~ @AGL 1 California @PERCENT_SERIES 0 1 2

PERSISTENT:

NO

REQUIREMENTS:

Crystal Reports 9 or Higher

ALSO SEE:

@CALC_PERCENT_SERIES

Next Macro Previous Macro Return to Alpha List

Next Macro in this Group Previous Macro in this Group Return to Group List