Forums >> Revit Structure >> Technical Support >> Calculated totals of formula in schedule

corbet

active

Joined: Mon, Jul 8, 2019
0 Posts
No Rating

Hi,

I want to create an electrical schedule that looks the same on each project, with a value of 0 if a particular item is not used in that project.

What I have done so far is placed one of each in the project and hidden them, than created my own 'count' column on the schedule.

I now want another total to show the actual calculated total minus 1.  I can't seem to use calculated total of the first formula in second formula that I put in as If(calc1=1,0,calc1-1).

Can someone please tell me where I'm going wrong. I'm sure it's simple but I can't work it out.

Thanks in advance for any assistance.

This user is offline

WWHub

site moderator|||

Joined: Tue, May 16, 2006
13079 Posts

First, I would not place the items and hide them.  I would put them in a workset that is turned off.

This should help you.  http://revitcat.blogspot.com/2019/08/hide-zero-values-in-multiple-item-rows.html

This user is offline

corbet

active

Joined: Mon, Jul 8, 2019
0 Posts
No Rating

Thanks for your suggestion. I think I forgot to mention that I'm trying to set up a template for all projects, however collaboration to set up worksets is not an option in a template.

I will try the link you posted and see how I go. If you have any other suggestion I would be greatful to hear.

This user is offline

corbet

active

Joined: Mon, Jul 8, 2019
0 Posts
No Rating

I still can't get the calculated total of MyCount in a formula. It just uses the formula of "1", meaning "1" minus 1 = 0

Not sure what it is I'm missing.

In essence all I want to do is show a new Count column which shows one less than the actual calculated total of the original Count column.

eg. if it says there are 4 items, I would like it show 3. I'm not bothered if it has zeros or just nothing. Please help!

This user is offline

WWHub

site moderator|||

Joined: Tue, May 16, 2006
13079 Posts

You need to show us an image of what your schedule looks like and your formulas.

This user is offline

corbet

active

Joined: Mon, Jul 8, 2019
0 Posts
No Rating

I hope this will make sense haha.

I have the schedule with what is looks like with no columns hidden, then each columns formula showing. The only column that does not have its totals calculated is the 'total 1', and the 'total' column has a formula of if(count calculated=1,0,count calculated -1)

I would like the end result to be a schedule that will look exactly the same on all projects, with three columns being - Symbol, Description, Quant. Quant is the column I want to indicate one less that what is currently showing. Thank you so much for trying to help. Appreciate it heaps.

Sorry if I'm not explaining this very well, I'm relatively new to all this formula and forum stuff. I tried to follow the methodology behind the only other problem that was remotely close to mine, allbeit from some time ago. This is it

This user is offline

corbet

active

Joined: Mon, Jul 8, 2019
0 Posts
No Rating

So I couldn't see mu formulas in the actual post so not sure what happened there. Maybe it's there and I just don't know how to see it!

Anyway I found that I could 'attach' a file, so I'm doing that now. Sorry, hope it works either way!

Attached Images

This user is offline

WWHub

site moderator|||

Joined: Tue, May 16, 2006
13079 Posts

Still trying to understand what you want vs what you have.  Perhaps if you edit your last image cicling what is wrong and what you think it should show will help.

This user is offline

Schedule totals are not calculated right: 1+1=1 [ 1 2 ]

17

which parameters can have totals in schedules?

2

Schedule Totals

1

Calculated value

5

Calculated Value

3