I have a calculation field of: field1/500. That calculation field is working; however, the answer has to round up.
Example: $4,235,623.00/500=$8471.246 The answer of $8471.246 has to round UP to the next whole number. I tried making the answer 0 decimal points but it then follows the .50> up, .49< rounds down. I thought it may have to be written as a javascript, but I'm not sure how to do that. Anyone have any ideas? Your input would be appreciated. Thanks!
Example: $4,235,623.00/500=$8471.246 The answer of $8471.246 has to round UP to the next whole number. I tried making the answer 0 decimal points but it then follows the .50> up, .49< rounds down. I thought it may have to be written as a javascript, but I'm not sure how to do that. Anyone have any ideas? Your input would be appreciated. Thanks!