SantasLittleHelper
Board Regular
- Joined
- Nov 25, 2016
- Messages
- 77
I have a calculated field with the following Expression:
The RecNo field is a regular autonumber field. I want the new calculated field to round the autonumber down to the nearest 100.
E.g.
<tbody>
</tbody>
With the current expression, I get #func ! error in each record
Code:
Round([RecNo],-2)
The RecNo field is a regular autonumber field. I want the new calculated field to round the autonumber down to the nearest 100.
E.g.
AutoNumber | Calculated Field |
78 | 0 |
150 | 100 |
399 | 300 |
1542 | 1500 |
<tbody>
</tbody>
With the current expression, I get #func ! error in each record