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
Gelöst! Gehe zur Lösung
Gelöst von rxi.gg. Gehe zur Lösung
What about Areas outside of those ranges such as 11, 13, 22, 41...? You get the drill.
They can be forgotten about in the schedule.. just want to display these specific ranges
Try and see if you can make it yourself:
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.
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 <
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.
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.
@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:
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.