New Freeform Text Substitutable Strings
The following substitutable strings have been added to Freeform Text:
&coltotCC, where CC is the column number from 1 to 20. The total of the numbers in the column will be substituted. Note that outlining is respected, so any numbers in a Summary row are ignored.
&colavgCC, where CC is the column number from 1 to 20. The average of the numbers in the column will be substituted. Note that outlining is respected, so any numbers in a Summary row are ignored. Also, any values of zero are ignored to ensure that rows intentionally left blank are ignored. If there are valid values of zero, then the average will not be correct.
&colCCsymSS, where CC is the column number from 1 to 20 and SS in the Toolbox symbol number from 1 to 64. The total number of symbols of Toolbox type SS will be substituted.
An example of the use of these strings is shown below:
