SOLVED
Is there a way to round up to 2 decimals no matter what the 3rd+ decimal is?
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
CherieACI
8 - Asteroid
‎02-21-2022
11:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have data in a field that sometimes has more than 2 decimals and when it does I need it to round up every time. Example: 150.3123 I need to round up to 150.32, so even though the 3rd decimal isn't above 5 I still need it to round up. (If there are more than 2 decimals then I need to round up every time) Can Alteryx do that?
Thank you in advance,
Cherie
Solved! Go to Solution.
Labels:
- Labels:
- Expression
4 REPLIES 4
20 - Arcturus
‎02-21-2022
12:04 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
how about:
... i like @atcodedog05 answer better ..
cheers,
mark
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
22 - Nova
‎02-21-2022
12:04 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎02-21-2022
02:42 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This solution worked! Thank you very much!
22 - Nova
‎02-21-2022
10:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help : ) @CherieACI
Cheers and have a nice day!
