Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
abbrechen
Suchergebnisse werden angezeigt für 
Anzeigen  nur  | Stattdessen suchen nach 
Meintest du: 

Using a formula to caluculate area range for rooms

8 ANTWORTEN 8
GELÖST
Antworten
Nachricht 1 von 9
AidanHawkins
471 Aufrufe, 8 Antworten

Using a formula to caluculate area range for rooms

Hi there, I have an office building 

with different room ranges:

 

 SMALL = 12m2

MEDIUM =19-21m2

LARGE = 35-40m2

 

I want to show these in a schedule, with LEVEL 2,3,4,5,6 in the columns side

And I want to show in the SMALL, MEDIUM, LARGE in the rows side of the column, with the count of how many I have on each floor.

 

What do I do to get this?

 

Thanks

 

 

8 ANTWORTEN 8
Nachricht 2 von 9
ToanDN
als Antwort auf: AidanHawkins

What about Areas outside of those ranges such as 11, 13, 22, 41...? You get the drill.

Nachricht 3 von 9
AidanHawkins
als Antwort auf: ToanDN

They can be forgotten about in the schedule.. just want to display these specific ranges

Nachricht 4 von 9
ToanDN
als Antwort auf: AidanHawkins

Try and see if you can make it yourself:

https://www.revitforum.org/node/1126

Nachricht 5 von 9
rxi.gg
als Antwort auf: AidanHawkins

Make you an example. @ToanDN is right you have ranges out...

S-ROOM 0-18 M2

M-ROOM 19-21 M2

L-ROOM +22 M2

Create 3 calculated values:

S-ROOM Formula: if(and(AREA>0,AREA<18),1,0)

M-ROOM Formula: if(and(AREA>19,AREA<21),1,0)

L-ROOM Formula: if(AREA>22,1,0)

 

Then you can group by level and calculate the totals

Roi G. | AUTODESK REVIT & DYNAMO EXPERT

Da un "Me gusta" si la respuesta te ha resultado útil y acéptala como solución si ha resuelto tu duda.
Give a "Like" if the answer has been useful to you and accept it as a solution if it has solved your doubt.

Nachricht 6 von 9
AidanHawkins
als Antwort auf: AidanHawkins

New example of what I want to do that will make things easier to understand.

 

I want to create a new schedule

I want to create a column that displays level 3,4,5,6

I want to create 2 rows that display SMALL and MEDIUM and these to display a count

 

SMALL is 0m2 - 13.89m2
MEDIUM is 15m2 - 24.60m2

 

When I use your forumula, it says - operator not expected <

Nachricht 7 von 9
rxi.gg
als Antwort auf: AidanHawkins

1.png2.png3.png4.png

Roi G. | AUTODESK REVIT & DYNAMO EXPERT

Da un "Me gusta" si la respuesta te ha resultado útil y acéptala como solución si ha resuelto tu duda.
Give a "Like" if the answer has been useful to you and accept it as a solution if it has solved your doubt.

Nachricht 8 von 9
barthbradley
als Antwort auf: AidanHawkins

Would you consider HEADERS instead of ROWS?  I'm pretty sure you can get there that way.  That is, a combination of Sorting/Grouping by Parameter Fields/Columns and ticking Header.  Going to require creating some Calculated Parameters  though, but these can be hidden.  

 

Headers v Rows.png

Nachricht 9 von 9
ToanDN
als Antwort auf: AidanHawkins


@AidanHawkins wrote:

New example of what I want to do that will make things easier to understand.

 

I want to create a new schedule

I want to create a column that displays level 3,4,5,6

I want to create 2 rows that display SMALL and MEDIUM and these to display a count

 

SMALL is 0m2 - 13.89m2
MEDIUM is 15m2 - 24.60m2

 

When I use your forumula, it says - operator not expected <


 

You can add one calculate text parameter using the formula:

if(Area < 13.90, "SMALL", if(and(Area > 14.99, Area < 24.61), "MEDIUM", " "))

 

Example:

ToanDN_0-1653411326575.png

 

ToanDN_1-1653411396205.png

 

Edit: removed my comment on @rxi.gg approach

 

Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.

In Foren veröffentlichen  

Autodesk Design & Make Report