RevitCity.com Logo

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

Welcome !

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

 

Forums

Forums >> Revit Building >> Technical Support >> Calculating two Formulas on the same row in a Schedule

Search this ThreadSearch this Thread | Page 1 of 1 |

Thu, Dec 16, 2010 at 2:19:01 PM | Calculating two Formulas on the same row in a Schedule

#1

designimpressions


active

Joined: Fri, Jun 6, 2008
47 Posts
No Rating


Hi, Can anyone tell me how to calculate two formulas on the same row please? I have created a Door Schedule and included a Cost Field with totals calculating, I have also created a Door Style Key Schedule which I added to the Door Schedule Fields alongside the Door Style Style Cost. Is there a Formula for calculating both Costs on the same row?

The three Costs Rows I have are: Door Style Cost, Cost and Total Cost. I want to Calculate the Door Style Cost & Cost so I have a Total Cost which I will want to calculate the totals of too. Please find attached a .png with a copy of the schedule.

Any help will be gratefully appreceated,

Thanks,

Peter



Attached Images

86165_Schedule.PNG

This user is offline

 

Thu, Dec 16, 2010 at 2:43:59 PM | Calculating two Formulas on the same row in a Schedule

#2

BDerrick


active

Joined: Thu, Jul 12, 2007
73 Posts
3.5 Stars: 3 Votes


You need to open the families and add shared parameters (if these cost parameters aren't already).  You'd have 'Door Style Cost', 'Cost' & 'Total Cost' shared parameters.  This will allow you to add a formula to the values as well as schedule the items in your project.  Add this formula to 'Total Cost': Door Style Cost+Cost.  hth

This user is offline

 

Thu, Dec 16, 2010 at 4:04:47 PM | Calculating two Formulas on the same row in a Schedule

#3

designimpressions


active

Joined: Fri, Jun 6, 2008
47 Posts
No Rating


Thanks BDerrick, I created shared parameters for the Door Style Cost, Door Cost & Total Cost as advised and added the following formula to the Total Cost Field: =Door Style Cost+Door Cost. I got an error saying the following string is not recognised: Door Style Cost. I checked the name of the shared parameter and it matches my input. Please find attached a .png with a copy of the revised schedule showing the error and formula.

 

Thanks,

 

Peter



Attached Images

86174_Schedule02.PNG

This user is offline

 

Thu, Dec 16, 2010 at 6:38:10 PM | Calculating two Formulas on the same row in a Schedule

#4

BDerrick


active

Joined: Thu, Jul 12, 2007
73 Posts
3.5 Stars: 3 Votes


Sorry, I should've been more clear.  You need to open the family and add the shared parameters.  The schedule itself cannot add 2 different parameters.  

This user is offline

 

Fri, Dec 17, 2010 at 1:22:56 PM | Calculating two Formulas on the same row in a Schedule

#5

designimpressions


active

Joined: Fri, Jun 6, 2008
47 Posts
No Rating


Thanks Bderrick,

I added the shared parameters directly in to the family but still couldn't get the formula calculating on the same row. I discovered that the Schedule can have two different parameters adding on the same row by using Calculated formulas in the Fields section of the Schedule Properties Dialogue Box. Please see attached .png.

 Thanks for your help,

 Peter 

 

 



Attached Images

86233_Schedule03.PNG

This user is offline

 

Search this ThreadSearch this Thread | Page 1 of 1 |



Similar Threads

Thread/Thread Starter

Forum

Last Post

Replies

Help! Need control of schedule row spacing.

Revit Building >> Technical Support

Wed, Jun 15, 2011 at 5:26:11 PM

7

Highlight every other Row in a Schedule

Revit Building >> Technical Support

Thu, Jul 9, 2020 at 2:11:59 PM

4

Parameter formulas losing calculated values

Revit Systems >> Technical Support

Wed, Jun 17, 2015 at 7:23:19 PM

1

Schedule will not allow me to add new data row

General Discussion >> Revit Project Management

Mon, Apr 27, 2015 at 12:53:54 PM

1

Schedule

Revit Building >> Technical Support

Wed, Apr 8, 2009 at 1:08:46 PM

1

Site Stats

Members:

1507897

Objects:

21231

Forum Posts:

151227

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.2432

Login

User Name:

Password:

Remember Me  

Forgot Password?

Search Forums

Advanced Search

Search Forums

Advanced Search


Clear Highlights


Clear Highlights