Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
abbrechen
Suchergebnisse werden angezeigt für 
Anzeigen  nur  | Stattdessen suchen nach 
Meintest du: 

Create a Schedule Formula to Multiply Count...?

6 ANTWORTEN 6
Antworten
Nachricht 1 von 7
spinalfarm
4344 Aufrufe, 6 Antworten

Create a Schedule Formula to Multiply Count...?

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.

 

Count Calculated.PNG

6 ANTWORTEN 6
Nachricht 2 von 7
ToanDN
als Antwort auf: spinalfarm


@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

Nachricht 3 von 7
spinalfarm
als Antwort auf: ToanDN

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,

Nachricht 4 von 7
ToanDN
als Antwort auf: spinalfarm


@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,


Annotation 2020-01-24 133836.jpgAnnotation 2020-01-24 134011.jpg

Nachricht 5 von 7
spinalfarm
als Antwort auf: ToanDN

Does not seem to like the Count Calculated formula (inside the schedule):

Formula.PNG

 

Thanks for your support!

Nachricht 6 von 7
ToanDN
als Antwort auf: spinalfarm

Look at my screenshot. There is no = inside the formula.
Nachricht 7 von 7
Anonymous
als Antwort auf: ToanDN

@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

Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.

In Foren veröffentlichen  

Autodesk Design & Make Report