Calculate Value of Average Unit Size in an Area Schedule for Units of Different Sizes

[jorgedelacova7458]

I have a schedule (image attached) where I am trying to calculate the average residential unit size for each unit type. The schedule has been collapsed (as in, I unchecked Itemize Each Instance in sorting) so that the Area is a grand total for that type. The problem is that some of the unit types have different areas, which "breaks" the schedule. Does anyone know how I can approach this issue? I created an "Area - Unitless") parameter, which is a calculated value of Area / 1 SF,. and the My Count parameter, which is a number Type parameter where I set the value to 1 (to be able to use the Count value).

[ToanDN · Accepted solution]

See the attached Revit 2022 file and see if it makes sense.

[jorgedelacova7458]

So close! For some reason, the first unit type did not populate with a calculation.

[ToanDN]

Itemized the schedule and see which rows don't return the value.

[jorgedelacova7458]

Please disregard. One of the areas was not enclosed. Thanks, @ToanDN  Your original solution worked.

[rjohnstonBK2JP]

Please upload an image of the formulas. It would be helpful for those who haven't upgraded to 2022 yet

My issue is that I have the formula as =(Area / Count) but the area parameter doesn't produce a number value if it's a calculated field. It only produces a field if it's itemized. 

[ToanDN]

[rjohnstonBK2JP]

The math makes no sense but it worked perfectly. That formula prints out as (Area / 100% * 100%) but somehow it gets the correct answer. Thanks for your help!

[ToanDN]

---

@rjohnstonBK2JP wrote:
The math makes no sense but it worked perfectly. That formula prints out as (Area / 100% * 100%) but somehow it gets the correct answer. Thanks for your help!

---

Math always makes sense.  (Area / 100% *100%) because you untick Itemize every instance box, so you get the Sum of every row which is of course, 100%.  Tick that box then you will see and understand.

[Kev_D]

@ToanDN 

This is great, and easily replicated from your file. But I am trying to understand it. How does the 'Percent' calculation work? How does it return a value? It calls for a percentage of 'Area' by 'Name'. How does 'Name' represent the grand total when it is only a text value?

Take the first line. I understand the value of 'Percent', since it returns that the area is 32.31% of the grand total (20.43m² is 32.31% of 63.24m²). But how does it get this from the 'Name' parameter?

What am I not seeing?

[ToanDN]

What it means is Percent = Area of each instance / Sum Area of all instances with the same Name.

[Kev_D]

It makes sense but it doesn't 🤔. There's nothing in that formula that suggests it will capture the grand total of the area if the names are the same. It's just Area by Name. Anyway, it works, so time to walk away. Revit does work in very mysterious ways!! 

[N_Vishak]

@ToanDN  Could you help me out with how I can calculate average area from the total residential area under Area use. I set the total unit count as a Parameter data and input the unit count.  Some how the formula I used , Area/Total Unit count, gives me "Improper Boolean expression". Appreciate the help. Thanks!

[Kev_D]

Total Unit Count is a text parameter.

Revit does not use text parameters in calculated values. Change Total Unit Count from Text to Number

[N_Vishak]

That worked !!! Thank you 🙂

[dlondonoEZXX8]

Have you ever tried this with 2-storey units?

[ToanDN]

---

@dlondonoEZXX8 wrote:

Have you ever tried this with 2-storey units?

---

No but it doesn't make any differences.

[andybrack]

@jorgedelacova7458 @ToanDN Thanks for launching this thread.  The solution came in handy yet again!