Roundup in Custom Columns
I am currently using a rounding feature to get my width and height to 1/16 precision, however i want to build on that rounded width with a block width.
This would need to "roundup or ceiling" function from my rounded variable to the next even inch.
Example (24.625 = 26.000) or (23.625 = 24.000)
roundup is not a valid token, and i am not sure if there is some way to tweak the existing tokens in a way to allow this.
Any help is appreciated…
Answers
-
This is possible with a formula column. In this example, it is using the ceiling function on the Measurement property so that you have a new column that is the Measurement value rounded up.
1 -
I'm not familiar with custom columns so I'm just spit-balling here.
In excel you would use EVEN(value). Is there somewhere to try this in your workflow?
0 -
Peter,
I tried this but it did not work for me. I am trying to get the width rounded in a new column that is rounded up to the next even inch.
Here is a picture of my current formula that get's me rounded to 1/16 of an inch.
0 -
-
Even is an invalid token???
1 -
If you do ceiling(Width), that should get it rounded up to the nearest inch
ceiling(10.3) would be 11
round (10.3) would be 10
floor(10.3) would be 10
0 -
-
Yes that is how they get block sizing for the glass industry.
0 -
Ahh… sorry I misunderstood that! To round up to the nearest EVEN number, do the following:
ceiling(Width * 0.5) * 2
1
Categories
- All Categories
- Certifications Overview ↗
- Bluebeam Certified Professional (BCP) ↗
- BCP User Group
- BCI User Group
- Welcome Guide
- Join the Discussion
- 3.4K Discussion Topics
- 313 Peer Support
- 565 Product Ideas & Feedback
- 2.5K Community Hub
- 11 What's New?
- Release Notes Website ↗
- Built Blog ↗
- Product Support
- 68 Bluebeam User Groups
- User Groups by Location
- United States
- Canada
- Europe
- Asia Pacific
- User Groups by Interest
- Architecture & Design
- Construction
- Engineering
- Subcontractors & Trades
- User Groups by Specialty Role
- Academic Educators
- Bluebeam Certified Instructors (BCIs)
- Bluebeam Certified Professionals (BCPs)
- Construction Owners & Owner Representatives
- Fresno State Student BUG (Fresno BUG)
- Global Bluebeam User Group Champions
- Government
- Product Ideas & Feedback