[Carl Wegman]

Can you share your custom column formula?

What options are you selecting, as well…

[Doug McLean]

should it not just be a typical stud wall formula?

[Carl Wegman]

Something like this?

[Doug McLean]

yes, but you should always use the Measurement column in your formulas ILO length

[Troy DeGroot]

@Doug McLean What’s your reason for using the Measurement value instead of the Length? If we use the PloyLength tool they’re the same value. You have me curious!

[Don Walke]

I’ve found that at times the measurement variable works in a formula when the length doesn’t. I think it has to do with the units assigned to a length whereas the measurement is strictly a value. An interesting side note, I use an area measurement and the associated length measurement in room take-offs ( floor area, ceiling area, wall area, base length, ect.) and if I assign a slope to the area measurement, the length value disappears. I can understand the logic in that if used for a room take-off, the sloped ceiling with a constant wall height the resulting wall area would be off. A hipped ceiling would be OK but any other configuration wouldn’t. I’m also trying to convert all of my profiles to using custom columns in lieu of the “depth” and “slope” value on the “Measurements” panel so I only have to open the “Properties” panel to see all of the values of a particular markup.

[Doug McLean]

its just the way Revu applies formulas.(plus good habits)
Without the benefit of an If statement, everything is global.
True, as long as all tools are the same type, i.e. Polylength, then it doesn’t matter, but if all of a sudden you need to apply your formula to an Area tool, things are quite different.

[Troy DeGroot]

Hey @carlwegman I haven’t played around with the “Ceiling” type variables in my formulas yet. I’m also not an Excel expert who may be most familiar with these types of entries. Can you give us an overview?

[Doug McLean]

its basically a rounding function, but it will always round up.
Floor is its opposite, which rounds down

[Troy DeGroot]

I’ve always tricked it by adding +0.4 to my formula. 🤣

[Jack Lee]

This is my custom formula as I work in metres and millimetres , but it won’t work for me

IMG_0267-rotated.jpeg 6 MB Image File - Click to view

• Copy Download Link

[Carl Wegman]

What unit is the length in? mm?

[Jack Lee]

The length is in metres, so should work as 20 m / .400mm would be 50 stud count.

[Doug McLean]

I see what your problem is. 400mm is .4 meters, not .400mm

You should always set metric scales as mm to mm. Never do mm to M, you’ll mess yourself up.

You should also use Measurement instead of length.

[Jack Lee]

Thank you, problem is i work in metres. How would i get the formula to work in this instance ?

[Doug McLean]

just use .4m instead of .400mm in your formula.
Or use 400mm.

[Jack Lee]

Thanks alot just changed to 0.4 and it worked. Not sure how this simple formula had me confused