Product
Support
Everything Else
Rounding with Percentages
A Caution about Rounding Percentages

Helix provides many format options for numeric values. But, when you round a number formatted as a percentage to the nearest 0.01, you may end up with unexpected results.

Numbers which are formatted as a percent are multipled by 100 for display purposes only. The underlying "rate" is the number that is actually stored. Thus, 1.67% is stored as 0.0167. If you round this to thenearest 0.01, it would be displayed as 0.02 or 2.00%. This may not be the result you desire.

  • Source Field.............................1.67%
  • How it is stored.......................0.0167
  • Rounding without percentage.....0.02
  • Rounding incorrectly.................2.00%
  • Rounding correctly...................1.67%

To correctly round a percentage, you must consistently use percentages, which means the second hole of the Round to Nearest tile should contain the value 0.01%:

Or, you could round to the nearest 0.0001 if you are more comfortable dealing with the underlying rate: