Where the Statistic being shown on a table or a chart is naturally a percentage, you can press the to display or hide the percentage sign.

In some situations, such as when computing Net Promoter Score the results of a calculate may be interpretable as percentages, but this button will not be available, as the statistic in which the outputs are stored, typically the Average, are not percentages.

A workaround is to:

- Place a statistic on the table that contains
`%`in its name. The example below assumes that this statistic is % Column Share; if you use a different statistic, make sure that you modify the code below. - Insert some Custom Rule to transfer the results from one statistic to another statistic that contains percentages. An example, which inserts the Average data into % Column Share is shown below. This code also renames the statistic as
**Net Promoter Score**. - Remove the original statistic from the table.
- If necessary, press .

```
var n_rows = table.numberRows;
var n_columns = table.numberColumns;
var averages = table.get("Average");
var percents = table.get("% Column Share");
for (var r = 0; r < n_rows; r++)
for (var c = 0; c < n_columns; c++)
percents[r][c] = averages[r][c];
table.set("% Column Share", percents);
form.setTranslation("% Total Share","Net Promoter Score");
```

## Next

How to Customize Fonts in a CreateCustomTable R Table

How to Customize Labels Used for Quarters in a Date Variable

## Comments

0 comments

Article is closed for comments.