|
|
Home | Forums |
Downloads | Gallery |
News & Articles | Resources |
Jobs | FAQ |
| Join |
Welcome !
|
84 Users Online (83 Members):
Show Users Online
- Most ever was 626 - Mon, Jan 12, 2015 at 2:00:17 PM |
Forums
Forums >> Revit Building >> Technical Support >> need help with a formula for my calculated value
|
|
active
Joined: Mon, Nov 27, 2006
24 Posts No Rating |
I have a formula that has worked in excel but does not work in revit. I'm using a formula takes a value (length of stud) and determines if its greater or less than 4'. In one outcome if its greater I then divide by 10' and then round that number up. The other outcome less than 4' I just use the actual number. The formula works if I don't plug in the ROUNDUP portion. Take a look at my formula and see what I'm missing, thank you.
if(Cut Length > 4,ROUNDUP((Cut Length / 10),0), (Cut Length))
|
This user is offline |
|
|
|
active
Joined: Wed, Oct 7, 2009
654 Posts
|
It looks like you aren't using the correct format for roundup (it should be "roundup(unitless number)"). I got this to work:
if(Cut Length > 4', (roundup(Cut Length / 10')) * 1', Cut Length)
That divides Cut Length by 10' to get a unitless number, rounds that up, then multiplies it by 1' to get it back to feet.
|
This user is offline |
|
|
active
Joined: Mon, Nov 27, 2006
24 Posts No Rating |
yeah that worked, thanks
|
This user is offline |
|
|
|
Similar Threads |
Calculated totals of formula in schedule |
Revit Structure >> Technical Support
|
Fri, Sep 11, 2020 at 7:14:07 AM
|
7
|
Calculated Value |
Revit Systems >> Technical Support
|
Mon, Dec 13, 2010 at 4:46:58 PM
|
3
|
Schedules - Calculated Value does not have "Count" in the list of fields |
Revit Building >> Technical Support
|
Thu, Oct 17, 2013 at 8:55:44 PM
|
2
|
Calculated value |
Revit Building >> Technical Support
|
Fri, Aug 6, 2010 at 2:17:19 PM
|
5
|
Improper use of Boolean Expression message with my calculated value formula |
Revit Building >> Technical Support
|
Thu, Jan 30, 2014 at 3:31:03 PM
|
2
|
|
|
Site Stats
Members: | 2022239 | Objects: | 22973 | Forum Posts: | 152200 | Job Listings: | 3 |
|