Monday, August 11, 2008

Multiply by count in schedules

When we try to multiply with the Count parameter in Revit, it spits out: "The field Count cannot be used in formulas.

image

For example, in a furniture schedule, after assigning $ values for various furniture, one cannot get an extended total for a set of particular items using the calculated value (= Count * Cost)

image

The work around is to create a calculated value named "ExtCost" (= Cost) which is equivalent to the cost parameter. The result looks like this.

image

Then go to the schedule properties > Formatting tab and select the ExtCost parameter and check Calculate Totals.

image

The result,

image

looks fine. But why do I have to do this?

6 comments:

Unknown said...

DOES THIS WORK WITH LENGTHS X COUNT TOO?

Unknown said...

DOES THIS WORK WITH LENGTH TOO?

Nicholas Iyadurai said...

Yes, it will.

Latif Ullah said...

MAAAAN, THANKS. May you have a Good Life Ahead

Nicholas Iyadurai said...

Wow... I wrote this in 2008. It still works in Revit? Revit has not updated their software to overcome this stupidity???????!

Latif Ullah said...

Haha Yeah Nicholas it is still Like that, I have used it again today hahaha Thanks