Schedule - Getting Total Area Customized

[sjiX3D8W]

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! 

[barthbradley]

Why don't you FILTER that Department out of Schedule then? 

[bin]

probably not. 

Maybe you need to create 2 separate schedules with filters and place them together. 

[sjiX3D8W]

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

[barthbradley]

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?  

[sjiX3D8W]

I tried something and got an error... Could you see and tell me if this was what you meant? 

Thanks! 

[barthbradley · Accepted solution]

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.

[sjiX3D8W]

Thanks! it worked!!

[manthan_hingoo]

How did you get total areas of all the departments? I am trying to make a schedule for it.