SOLVED
Round off
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
SiddeshDhruva
7 - Meteor
‎05-27-2021
09:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, I am looking for a similar solution but in a different output, i want to split my data as below
1, Decimal value
2, Scenario 1 - Nearest "0"
3, Scenario 2 - Nearest "10"
4, Scenario 3 - Nearest "100"
below is the example:
Spend number | Decimal Value | Scenario 1(Nearest "0") | Scenario 2, Nearest 10 | Scenario 3, Nearest 100 |
141.34 | 0.34 | 141 | 140 | 100 |
please suggest
Thank you!
Solved! Go to Solution.
Labels:
- Labels:
- Topic of Interest
4 REPLIES 4
22 - Nova
‎05-27-2021
10:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎05-27-2021
10:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you! it worked, however for nearest 10 section, i want the formula to round down to near 10, ex: if the spend is 117 it should round down to 110 instead 120, is there any tweak in the formula?
22 - Nova
‎05-27-2021
10:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here is how you can do. I am dividing it by 10 finding the lower bound decimal of the value and the multiply by 10. Same strategy for 100.
Workflow:
Hope this helps 🙂
‎05-27-2021
10:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
awesome:) exactly the same I wanted, thanks a ton:)
