Scheduling Area and Using Calculated Value - Inconsistant Units error

[Anonymous]

Howdy. As seen in the screen shot, I use Revit Links to build projects. I need to count the number of links, get area information off of them, and total it up. I am trying to manually find the Total Area by creating a formula to multiply the unit count and area. You can see the error in the screen shot. 

Thank you for the consideration. I hope you understand I must do this via formulas, as we want to generate many different types of area totals besides 'gross total'. 

[piotr.bocian]

Formula should be: Area / 1 SF * Unit Count

[Anonymous]

Strange. Almost right. Why do I have divide out the SF integer? Also. It's not multiplying the two

[piotr.bocian]

If you need to create number parameter it need to be without unit, so you need to divide by area unit.

But you can create 'Area' parameter and there will be Area * Unit Count

[ToanDN]

[Anonymous]

I have been able to add in a Calculated Value by your guidance, but the formula suggested by Piotr does not work.

I have also tried the formula;   ((Area/ 1sf) * Unit Count)

This formula gives me an Inconsistent Integers error

Edit; Also included is a screenshot showing how I get my count from a Calculated Value. It's formula is = 1. Is this the cause of the error?

[ToanDN]

- Create a Calculate Value, name it Total Area per Unit Type, set the parameter type to Area, not Number

- Enter in the formula: Area

- Go to Formatting Tab, select Total Area per Unit Type field and set it to Calculate Totals

That's it.

[piotr.bocian · Accepted solution]

I'm not sure what are you going to achieve. But as you can see formula Area / 1 SF * Unit Count, that I gave you work. The problem is with parmeter Unit Count because it has value 1, so if you multiply Area by 1 you get Area.

If you need to calculate Area by some integer, add parameter with formula as I gave you, but Unit Count should be added as new parameter instead of calculated parameter.

[Corsten.Au]

Hi..

I am trying to give my thoughts here.. may be I totally misunderstood the problem... 

but I still think Area calculation is pretty straight forward in Revit and there are tools available to do that..

Calculate Totals should work.. usually there is no need to multiply by count...

I have attached Revit file for reference..

Unit area - Area

Total Area - Area ( Calculated )

Rooms with Names and areaParameters

Calculated Totals takes care of " Count"

Schedule needs to be sorted correctly, any filters.. Custom parameters should match with Linked files

if Rooms are extracted from Linked model..

one can put custom factor/parameter to calculate..

just that revit is too technical when it comes down to UNITS...

Example 

length - meters

Area - Square meter

a ( Length ) x b ( Length ) = c ( Area) 

Square root of c (Area ) = d ( length) 

one has to keep looking for the unit changes logically...

Best luck