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.
PercentOfTotal (arg1,arg2)
where:
arg1 is a component of the running total (arg2), usually a row or column reference.
arg2 is the running total relative to arg1, usually a cell reference containing the grand total.
arg1 is divided by arg2 with the result multiplied by 100. Arg1 and arg2 are one or more of the following values:
A numeric value. For example, PercentofTotal(100,20) returns the value 500. Numeric values can include decimals and negative values.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. See Row, Column, or Cell Reference Arguments. | |
Return the value of 5 percent.
Divide the value of each cell in column A by the total market value in cell A5, multiply the result by 100, and display the resulting PercentOfTotal in column B.
PercentOfTotal ([A],[A,5])
Using the above example, the following table shows the PercentOfTotal results in column B: