Forums >> Revit Building >> Technical Support >> need help with a formula for my calculated value

sippel26

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

TKennedy

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

sippel26

active

Joined: Mon, Nov 27, 2006
24 Posts
No Rating

yeah that worked, thanks

This user is offline

Calculated totals of formula in schedule

7

Calculated Value

3

Schedules - Calculated Value does not have "Count" in the list of fields

2

Calculated value

5

Improper use of Boolean Expression message with my calculated value formula

2