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:
