View Full Version : Schedules : Invalid Formula
Chad Smith
2004-01-08, 06:09 AM
Refer attached image.
I am trying to do a very simple cost calculation in a wall schedule, using the R6.0 tutorial as a guide. But I keep getting an 'Invalid Formula' error.
The right idea chad but AFAIK cost doesn't have units. So what you need is this:
( Cost / 1' ^ 2 ) * Area
HTH
Guy
hand471037
2004-01-08, 04:00 PM
Another thing that always gets me when making formula is that they are case-sensitive. It will give the same error. I always screw that up!
Hi Chad
Of course being the 21st century we would be using metric in the rest of the world, so your formula would be -
( Cost / 1000.0 mm ^ 2 ) * Area
Chad Smith
2004-01-09, 04:22 AM
I have been playing around with this a little and have noticed that 'Area * Cost / (1'^2)' does work with imperial but not with metric.
Is this a bug? Can someone else play with this theory and confirm.
Chad Smith
2004-01-09, 04:25 AM
( Cost / 1000.0 mm ^ 2 ) * Area
:banghead: Thanks.
No worries. The trick with a Revit formula is usually in the units or mixing up 'types'. You will find this is the same when you build a formula in a family. Of course the formula I put in is still wrong as it really should be... ( Area / 1000.0 mm ^ 2 ) * Cost
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.