Forums
Forums >> Revit Building >> Technical Support >> Formulas for Schedules
|
|
active
Joined: Fri, Oct 10, 2008
21 Posts No Rating |
I'm trying to calculate Pricing for material or better yet a wall. I set up a Wall Schedule Quantities and Pricing Schedule and within the schedule I'm trying to get the Area and the Cost to multiply, under a Price field, but it doesn't seem to reconize the fields or formula that I'm typing in. Has anyone trying to create a schedule like this in their template or can anyone help me figure this out. I'm this close to saving the company the headache of actually doing a quantity take-off... Please let me know if you can help or if you have something like this that can help me better understand how to create this formulas. Thank you
|
This user is offline |
|
 |
|
site moderator|||
Joined: Tue, May 16, 2006
13079 Posts
 |
TipIn formulas, keep units consistent. Do not mix units.
|
This user is offline |
|
 |
active
Joined: Fri, Oct 10, 2008
21 Posts No Rating |
WWHub, thank you for your prompt response, BUT........... I'm not able to make it work.... Let me see if I can give you more detail. I created a schedule for a roof material area. The fields that I added were, Type and Family, Area and Cost... I went to calculate value and created a Price field and added the following to the formual box... Area*Cost. It didn't allow me to change the cost units, from currency to whatever... But, you see what I'm trying to do, right? Please help... Thank You,
|
This user is offline |
|
 |
active
Joined: Tue, Apr 12, 2005
1310 Posts
 |
The units need to be consistent. You can create an additional parameter (Area) that equals 1. In your formula use that to get the units consistent, such as "Total cost= Area/Area A * Cost"
|
This user is offline |
View Website
|
 |
active
Joined: Fri, Oct 10, 2008
21 Posts No Rating |
WWHub, That worked... Thank you so much... You don't know how much time you just saved me, for future projects... Thank you, again...
|
This user is offline |
|
 |
 |
Similar Threads |
Adding formulas to schedules |
Revit Building >> Technical Support
|
Mon, Nov 5, 2007 at 6:07:49 PM
|
0
|
Understanding Formulas |
Revit Building >> Technical Support
|
Tue, Nov 16, 2010 at 1:36:05 PM
|
14
|
Schedules and formulas |
Revit Building >> Technical Support
|
Tue, Jun 9, 2009 at 12:53:23 PM
|
5
|
Formulas and Schedules for Revit |
Revit Building >> Technical Support
|
Thu, Sep 13, 2007 at 9:06:07 AM
|
5
|
structure analys with Revit |
Revit Structure >> Technical Support
|
Thu, May 11, 2006 at 12:30:26 PM
|
2
|
 |
|
Site Stats
Members: | 2110755 | Objects: | 23189 | Forum Posts: | 152303 | Job Listings: | 3 |
|