Using count in furniture schedules

[irene_garcia22UG7]

Hello!

I am working in a refurbishment project where we have to reuse as much as we can from the existing furniture. 
I would like to see how many elements of each type have not been used yet. 
I have set a furniture schedule where I would like to have a row which shows the elements not in use.

This is the process I have followed:
1) Set a new type parameter (Existing) where the number of units can be written manually.

2) Set a new count parameter as it is not possible to use the count parameter in formulas. That parameter has to be formatted into calculate totals (new count)

3) Create a new formula (not in use) = Existing - new count

The formula is not reading the calculated totals, but the unit, so it is only substracting 1 (see image 1). If we calculate totals in the not in use parameter it is not giving the right values either (see image 2)

   

I hope someone can help me out with this, I have read the forum but cannot find anything that helps!

Have a nice day 🙂

[jay_colcombe]

A very simple way could be to select the items which are existing and set the "Phasing" in the Properties Palette from New Construction to Existing

Then create a quick Furniture Schedule for the New Construction Phase and then you can duplicate it and simply change the Properties Palette > Phase to Existing for this Schedule

When things get added or changed these will update and also you could create a view filter to colour them in plan to differentiate from New/Existing

you can always create a Total too using "Show All"  or "None" in the Phase Filter

If i was going full-on mode i would create a Shared Parameter in the Furniture Family with a Yes/No for existing and create my schedule this way