PercentOfTotal is a mathematical function that returns the result of a numeric value, row, column, or cell divided by another numeric value, row, column, or cell which is multiplied by 100. The function syntax is:
PercentOfTotal (arg1, arg2)
where arg1 is a component of the running total (arg2). Normally, this is a row or column reference.
where arg2 is the running total relative to arg1. Normally this is a cell reference containing the grand total.
arg1 is divided by arg2, with the result multiplied by 100. Arg1 and arg2 are expressed by one or more of the following arguments:
A numeric value. For example, PercentofTotal (100, 20) returns the value 500. Numeric values can include decimals and negative values. For a description of numeric arguments, see Numeric Arguments. | |
A pointer to a row, column, or cell within a grid. References can be specified in several ways. The reference syntax is: GridName.GridElement[segment(range)].Property For more information, see Row, Column, or Cell Reference Arguments. | |
An embedded function. For a list of mathematical functions, see Mathematical Functions. |
The following example returns the value of 5 percent.
The following example divides the value of each cell in column A by the Total Mkt value in cell A5, multiplies the result by 100, and displays the resulting PercentOfTotal in column B. The formula:
PercentOfTotal ([A], [A,5]),
Using the above example, the following table shows the PercentOfTotal results in column B: