Hi.
I was wondering if I can get the Total Area of certain conditions only.
I assigned departments and got the total areas for each department.
but I want to exclude 1 department in total area.
If you see the image attached, I want to exclude blue (but want to show it in the schedule).
I want to add the yellows and show them as total area.
Is there any way that I can calculate the areas in certain conditions? (maybe if function??)
Does anyone have any idea??
Thanks!
Gelöst! Gehe zur Lösung
Gelöst von barthbradley. Gehe zur Lösung
probably not.
Maybe you need to create 2 separate schedules with filters and place them together.
I am comparing several options and one has outdoor circulation.
I want to show the size of the corridor even though they are outside circulation.
But I don't want to include that into total, because it is not an enclosed space.
What I did for now is creating 2 separate schedules and placed it next to each other.
Out of curiosity, I was wondering if there is any smarter way to do this...
Include the outdoor area in the Schedule and create a Calculated Parameter Area Column (e.g. "Area 2") to total just the inside Areas. The Calculate Parameter would use a formula to carry over all the inside Areas, and not carry over the outside Areas. For example =if([Outside Area], 0, Area) --- where [Outside Area] is some identifier such as Mark or Comment. That make sense?
I tried something and got an error... Could you see and tell me if this was what you meant?
Thanks!
Conditional statements can only evaluate numeric values, numeric parameter names, and Yes/No parameters. You could create a Yes/No Project Parameter for each Area, and then the Calculated Parameter "Area2 - indoor only" if statement could be =if([Yes/No], 0, Area) -- where [Yes/No] is the Project Parameter and the checkbox status is checked.
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.