|
|
|
Home | Forums |
Downloads | Gallery |
News & Articles | Resources |
Jobs | FAQ |
| Join |
Welcome !
|
43 Users Online (42 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
|
|
|
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
|
This user is offline |
|
 | |
|
|
active
Joined: Thu, Jul 12, 2007
73 Posts
 |
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 |
|
|
|
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
|
This user is offline |
|
|
|
active
Joined: Thu, Jul 12, 2007
73 Posts
|
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 |
|
|
|
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
|
This user is offline |
|
|
|
Similar Threads |
|
Help! Need control of schedule row spacing. |
Revit Building >> Technical Support
|
Wed, Jun 15, 2011 at 12:26:11 PM
|
7
|
|
Highlight every other Row in a Schedule |
Revit Building >> Technical Support
|
Thu, Jul 9, 2020 at 9:11:59 AM
|
4
|
|
Parameter formulas losing calculated values |
Revit Systems >> Technical Support
|
Wed, Jun 17, 2015 at 2:23:19 PM
|
1
|
|
Schedule will not allow me to add new data row |
General Discussion >> Revit Project Management
|
Mon, Apr 27, 2015 at 7:53:54 AM
|
1
|
|
Schedule |
Revit Building >> Technical Support
|
Wed, Apr 8, 2009 at 8:08:46 AM
|
1
|
|
|
Site Stats
Members: | 1987524 | Objects: | 22875 | Forum Posts: | 152177 | Job Listings: | 3 |
|
Search
