Schedules : Invalid Formula

[Chad Smith]

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.

[GuyR]

The right idea chad but AFAIK cost doesn't have units. So what you need is this:

( Cost / 1' ^ 2 ) * Area

HTH

Guy

[hand471037]

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!

[sbm]

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]

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]

( Cost / 1000.0 mm ^ 2 ) * Area
:banghead: Thanks.

[sbm]

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