SOLVED
Round formula calculating NULL for every record
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
CDIns
8 - Asteroid
‎07-29-2024
08:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I added a formula tool onto my dataset to calculate like a rate. This works fine, however, the rates are like 12 decimals long. The system these rates will be uploaded to only can handle up to 5 decimal places. Directly under my rate formula, I created another formula referencing my rate column and using the following formula:
round([Rate],0.00000)
Its calculating NULL for every record. For reference, my RATE column is double data type.
Is my formula incorrect?
thank you,
Solved! Go to Solution.
Labels:
2 REPLIES 2
binuacs
21 - Polaris
‎07-29-2024
08:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@CDIns the formula should be Rate([Rate],0.00001)
‎07-29-2024
08:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Ah, I see what i did wrong. thank you, @binuacs !
