Create a Schedule Formula to Multiply Count...?

[spinalfarm]

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.

[ToanDN]

---

@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

[spinalfarm]

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,

[ToanDN]

---

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

---

[spinalfarm]

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

Thanks for your support!

[ToanDN]

Look at my screenshot. There is no = inside the formula.

[Anonymous]

@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