Schedule Advance

[FrankCv]

I am creating a schedule that shows me the number of units in a residential building by floor. I need to resolve two issues: first, I need the number of units of the same type to appear in a single row according to the floors; second, I need it to count the numbers. In this case, on floor 15, it only shows me one unit with the following IF formula ( {Property:General Parameters/Home Story Name} = “LEVEL 15”, 1, 0), but it should count two. What should I do?

Operating system used: Windows

[Ricardo Lopez]

Hi @FrankCv 

What do you mean by "unit"? A zone/room type, apartment...?

Anyway, if you meant zone type, create a new string value property named Unit type, available for Space classification in the Property Manager.

In the new scheme settings stablish a criteria so only zones with a custom value for Unit type property are shown.

Then select the fields: Home Story Number, Unit type and Quantity.

Check Home Story Number as a group and Quantity as a sum. 

[FrankCv]

Hello Ricardo, thank you for receiving my comments. Please find attached some images with my questions. Thank you very much for your help.

In this schedule, you will see that they refer to a zone that covers the area of the units. Each zone corresponds to a type of unit. The problems here are: 1. It is showing me only one unit of the same type per floor when in some cases there are more than one, and 2. It places one row for each level.In this other image, I show you how I configured the schedule. Each number corresponds to a level, and each level is a numerical expression.numerical expression by levels corresponding to what is contained in the main level folder