Last Modified Date: 03 May 2016
- Create a calculated field that finds the last digit of the number. For example:
FLOAT(RIGHT(STR([Amount]),1)). In this case 1.2 will return a value of 2.
- Create an IF statement that uses this amount, and then adds the number necessary to round up to the next whole number:
If [Last Digit In Field] > 0 Then [Amount] + ((1 - [Last Digit In Field]*.1)) Else [Amount] End
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials