topic Re: Scheduling Area and Using Calculated Value - Inconsistant Units error in Revit Architecture Forum

Scheduling Area and Using Calculated Value - Inconsistant Units error

Anonymous — Mon, 10 Dec 2018 14:55:01 GMT

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'.

Re: Scheduling Area and Using Calculated Value - Inconsistant Units error

piotr.bocian — Mon, 10 Dec 2018 15:05:36 GMT

Formula should be: Area / 1 SF * Unit Count

Re: Scheduling Area and Using Calculated Value - Inconsistant Units error

Anonymous — Mon, 10 Dec 2018 15:13:30 GMT

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

Re: Scheduling Area and Using Calculated Value - Inconsistant Units error

piotr.bocian — Mon, 10 Dec 2018 15:31:48 GMT

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

Re: Scheduling Area and Using Calculated Value - Inconsistant Units error

ToanDN — Mon, 10 Dec 2018 17:18:37 GMT

Re: Scheduling Area and Using Calculated Value - Inconsistant Units error

Anonymous — Mon, 10 Dec 2018 18:04:32 GMT

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?

Re: Scheduling Area and Using Calculated Value - Inconsistant Units error

ToanDN — Mon, 10 Dec 2018 18:17:37 GMT

- 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.

Re: Scheduling Area and Using Calculated Value - Inconsistant Units error

piotr.bocian — Mon, 10 Dec 2018 19:44:39 GMT

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.

Re: Scheduling Area and Using Calculated Value - Inconsistant Units error

Corsten.Au — Tue, 11 Dec 2018 05:10:38 GMT

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