& Construction

Integrated BIM tools, including Revit, AutoCAD, and Civil 3D
& Manufacturing

Professional CAD/CAM tools built on Inventor and AutoCAD
Integrated BIM tools, including Revit, AutoCAD, and Civil 3D
Professional CAD/CAM tools built on Inventor and AutoCAD
So, we have a schedule documenting parking stalls:
A) Accessible
B) Small
C) Standard
We would like to take the count of the 'Accessible' & multiply it by TWO (2.) So, we assume a new column will need to be created.
1) I have uncovered we cannot use the COUNT in the formula so I have created the formula to replicate COUNT so we can use it. I have called it "Count Calculated"
2) I have discovered we cannot JUST use the text "Accessible" it appears this wants to be a yes/no parameter?
I think I should be on the track of a nested if statement?
Guessing basically something like this:
if(not(Description = "Accessible"), Count Calculated, Count Calculated * 2)
Any help/ suggestions would be super.
@spinalfarm wrote:
So, we have a schedule documenting parking stalls:
A) Accessible
B) Small
C) Standard
We would like to take the count of the 'Accessible' & multiply it by TWO (2.) So, we assume a new column will need to be created.
1) I have uncovered we cannot use the COUNT in the formula so I have created the formula to replicate COUNT so we can use it. I have called it "Count Calculated"
2) I have discovered we cannot JUST use the text "Accessible" it appears this wants to be a yes/no parameter?
- Create a Yes/No parameter and Name it Accessible
- Select all accessible parking and tick the Accessible box
- Count Calculated is a calculated number parameter, formula = if (Accessible, 2, 1)
- Format Count Calculated field to Calculate Total so that you will have the total count in the schedule
ToanDN,
Okay,
1) I have the Yes/No as a Shared Parameter inside the stall family & boxes checked.
2) Is the "Calculated Count" also a shared parameter but in the project? Or a Scheduled Field inside the schedule?
Thanks,
@spinalfarm wrote:
ToanDN,
Okay,
1) I have the Yes/No as a Shared Parameter inside the stall family & boxes checked.
It is okay but not necessary. You can add the Y/N parameter as a project Type parameter (shared is unnecessary) directly when edit the schedule.
2) Is the "Calculated Count" also a shared parameter but in the project? Or a Scheduled Field inside the schedule?
No. It is a Calculated value parameter added to the schedule (Go to Fields Tab > click the fx icon in the middle).
Thanks,
Does not seem to like the Count Calculated formula (inside the schedule):
Thanks for your support!
@ToanDN Hi, thanks for your solution I truly appreciate it.
Could you please give me some advice, on which one is easier, creating a family parameter or a project parameter. I opened the project parameters and got all confused. Thanks in Advance
How to buy
Privacy | Do not sell or share my personal information | Cookie preferences | Report noncompliance | Terms of use | Legal | © 2025 Autodesk Inc. All rights reserved
Type a product name