RevitCity.com Logo

Home  |  Forums  |  Downloads  |  Gallery  |  News & Articles  |  Resources  |  Jobs  |  FAQ  |  SearchSearch  |  Join  |  LoginLogin

Welcome !

285 Users Online (127 Members): Show Users Online - Most ever was 626 - Mon, Jan 12, 2015 at 2:00:17 PM

 

Forums

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

Search this ThreadSearch this Thread | Page 1 of 1 |

Thu, Sep 3, 2020 at 2:36:59 AM | Calculated totals of formula in schedule

#1

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

 

Thu, Sep 3, 2020 at 1:03:35 PM | Calculated totals of formula in schedule

#2

WWHub


site moderator|||

Joined: Tue, May 16, 2006
13079 Posts
3.5 Stars: 356 Votes


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

 

Mon, Sep 7, 2020 at 1:27:53 AM | Calculated totals of formula in schedule

#3

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

 

Mon, Sep 7, 2020 at 2:48:55 AM | Calculated totals of formula in schedule

#4

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

 

Mon, Sep 7, 2020 at 2:47:51 PM | Calculated totals of formula in schedule

#5

WWHub


site moderator|||

Joined: Tue, May 16, 2006
13079 Posts
3.5 Stars: 356 Votes


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

 


This user is offline

 

Mon, Sep 7, 2020 at 11:13:12 PM | Calculated totals of formula in schedule

#6

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

 

Mon, Sep 7, 2020 at 11:18:57 PM | Calculated totals of formula in schedule

#7

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

160796_Capture_all.PNG

This user is offline

 

Fri, Sep 11, 2020 at 12:14:07 PM | Calculated totals of formula in schedule

#8

WWHub


site moderator|||

Joined: Tue, May 16, 2006
13079 Posts
3.5 Stars: 356 Votes


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

 

Search this ThreadSearch this Thread | Page 1 of 1 |



Similar Threads

Thread/Thread Starter

Forum

Last Post

Replies

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

Revit Building >> Technical Support

Tue, Apr 21, 2015 at 6:27:21 PM

17

which parameters can have totals in schedules?

Revit Structure >> Technical Support

Fri, Nov 8, 2013 at 4:37:49 PM

2

Schedule Totals

Revit Structure >> Tips & Tricks

Wed, Jan 6, 2010 at 8:00:46 PM

1

Calculated value

Revit Building >> Technical Support

Fri, Aug 6, 2010 at 7:17:19 PM

5

Calculated Value

Revit Systems >> Technical Support

Mon, Dec 13, 2010 at 10:46:58 PM

3

Site Stats

Members:

1492184

Objects:

21158

Forum Posts:

151139

Job Listings:

3

Sponsored Ads

Home | Forums | Downloads | Gallery | News & Articles | Resources | Jobs | Search | Advertise | About RevitCity.com | Link To Us | Site Map | Member List | Firm List | Contact Us

Copyright 2003-2010 Pierced Media LC, a design company. All Rights Reserved.

Page generation time: 0.2661

Login

User Name:

Password:

Remember Me  

Forgot Password?

Search Forums

Advanced Search

Search Forums

Advanced Search


Clear Highlights


Clear Highlights