Uncooperative Calculated Values in Furniture Schedule

[Sahay_R]

What's wrong with this schedule? 

This is what I need to see - with Itemize Each Instance unchecked

The highlighted fields are formula driven - 

Both Total Existing and Total Proposed are Shared Number Parameters. 

I understand that this is a problem, that prevents the formula from working - 

Is there any way around this? I don't want to ask my team to calculate and manually enter values!

Thank you in advance....

[barthbradley]

Hiya Rina.

Can you post it? 

[ToanDN · Accepted solution]

You need to enter 0 for all blank cells of Existing Seats, Existing BF, New Seats, New BF.

[Sahay_R]

Here's the deal, @ToanDN  - can't add the 0s. The Proposed Seats and Proposed BFs have a Shared Parameter with a value of 1 so that they schedule by that parameter and give actual counts. The Existing is an invisible 'dummy' family that has a Shared Parameter for the sole purpose of entering the numbers since we do not want to model the existing seating. 

Per @barthbradley 's wish - here is a link to the file - 

https://autode.sk/38lRQKC

[ToanDN]

Who says you can't?  

[Sahay_R]

OK - you added the parameters to the project - that was the step that I was missing....THANK YOU!

[ToanDN]

I just edit the parameters directly from the schedule and assign them to the Rooms/Doors categories.  By the way, you don't need to use shared parameters for any of those fields, everything can be added as non-shared parameters directly in the project's schedule.

[Sahay_R]

I just assigned them to Furniture. How did you edit the parameters right out of the schedule?

(Hang on - I see them as Shared Parameters assigned to Furniture and Rooms in your project....)

And also - those parameters come from the Families, and if they aren't Shared I can't schedule for that parameter....

[ToanDN]

Fields tab, select the parameter, Edit button, tick Add to all... box, then tick the category box(es).

[Sahay_R]

Aahh. Another way to add a Shared parameter to the project..... Thank you!

[Sahay_R]

And now what's wrong with this?

This is the desired result....

[ToanDN]

You cannot divide by zero.

[Sahay_R]

After coming so far.....

What would you suggest? Creating hidden fields for Total Existing and Total Proposed, and using them in a calculated field for the Percentage Decrease?> My head hurts now......

[ToanDN · Accepted solution]

I suggest you use the furniture schedule to get the count of the new pieces, then re-enter them in a room schedule to get the calculated % and whatnots.

[Sahay_R]

Would that mean stitching the two schedules together on the sheet? A FrankenSchedule, so as to speak?

[ToanDN · Accepted solution]

Since you have to re-enter the values to the room schedule anyways so just use one schedule.  Keep the furniture schedule for validation should the design changes.

[Sahay_R · Accepted solution]

Right - that's what I did - created two hidden fields, manually entered the numbers in there to feed the calculated parameter that gave the percentage decrease values. All is well now.