Help with Area Schedule

[gzavalagaMP7PK]

Hello, I need help creating an area breakdown schedule for a project I'm working on. The image below is what I'm trying to accomplish, right now this schedule only has the SF in just text that I would have to manually add. Is there a way to have areas be divided into different categories automatically (retail, resident, amenity, etc?).

[Alfredo_Medina]

Yes, if you enter something in a parameter of each Area item, such as in "Department". Then you can sort your schedule by levels then by department. The appearance will be different than in your sample image. 

[ToanDN]

Yes. You would add a set of yes no parameter for the type of use, and a set of calculated value parameters to show the value when the yn conditions are met.

[gzavalagaMP7PK]

Thank you. I created the yes/no parameters for each use, how can I create the calculated value parameter?

[ToanDN]

Add Calculated Value Parameter:

- name = AMENITY AREA

- type = Area

- formula: if (AMENITY, Area, 0)

Repeat for all others.

[gzavalagaMP7PK]

Thank you! I still seem to be having problems with the formula, I'm getting error messages when I put the commas, and when I delete them:

[gzavalagaMP7PK]

.

[ralphdenhaan]

Hi,

Use exactly this formula:

if(AMENITY, Area, 0)

[gzavalagaMP7PK]

Thank you! This added the column to my schedule but there's nothing under it 😕

[syman2000]

You have to go to formatting and set the calculated value as count total.

[ralphdenhaan]

You also have to check the boxes in the schedule in order to get a value. They are probably greyed out for now.