Results 1 to 6 of 6

Thread: Formula Help

  1. #1
    100 Club
    Join Date
    2010-10
    Posts
    105
    Login to Give a bone
    0

    Default Formula Help

    I'm having no luck with making formulas.

    I have found virtually nothing in the documentation from Adesk, big suprise. Other than great advice like '+' sign : use for addition. Thanks.

    For example, I'm trying to create a field in a schedule that will just multiply an Area (in the schedule) by 0.2. So I type "Area*.2" and the program returns the error message 'Inconsistent Units'.

    Clearly I have no idea what I'm doing, Are there any resources or documents floating around that would describe the basics of how to set them up?

    gt

  2. #2
    100 Club cganiere's Avatar
    Join Date
    2015-09
    Location
    Costa Mesa, California
    Posts
    117
    Login to Give a bone
    0

    Default Re: Formula Help

    Remove the inches mark from your formula.

    If you post an abbreviated form of your project file we can take a look at it.

    You can also use the "search" function on AUGI and find many posts on creating formulas and using schedules.

  3. #3
    Member
    Join Date
    2011-01
    Posts
    9
    Login to Give a bone
    0

    Default Re: Formula Help

    Change the parameter type that you're calulating to an area. If you're multiplying AREA * NUMBER, the result has to be an area because the number ( .2 in your case) has no units. You can always change the formating of the parameter to not display the units. There are some basic formula descriptions in the help menu that should get you started.

  4. #4
    100 Club
    Join Date
    2010-10
    Posts
    105
    Login to Give a bone
    0

    Default Re: Formula Help

    Quote Originally Posted by chris.macko View Post
    Change the parameter type that you're calulating to an area. If you're multiplying AREA * NUMBER, the result has to be an area because the number ( .2 in your case) has no units. You can always change the formating of the parameter to not display the units. There are some basic formula descriptions in the help menu that should get you started.
    In the User Guide from Adesk, there is chapter 63, approx. 2.5 pages. Provides no real description of how to work with formulas, just simplistic things like '+' sign for add and '*' for multiplication. Is there another place to look in the documentation / help?

  5. #5
    Certifiable AUGI Addict Dimitri Harvalias's Avatar
    Join Date
    2015-12
    Location
    Vancouver, BC Canada
    Posts
    3,753
    Login to Give a bone
    0

    Default Re: Formula Help

    You are right. There aren't a lot of sources fo this information and a few more relevant examples from Autodesk would be helpful.
    The 'inconsistent units' error is very common when first starting out with families. As Chris suggested AREA is measured in square units and the multiplier (.2) is simply a number. You have two ways to make those units consistent. If your calculated value is set to be a number type then you need to 'flatten' the squared units. If this is your approach the formula would be (Area/1) *.2. The 1 effectively divides the area by 1 square meter to make it a number.
    If you set the calculated value to be an Area type the calculation should work.

    Stick with it and try not to get frustrated. Once you get the hang of it it gets easier. In the interim, keep posting and we'll give you a hand.

  6. #6
    100 Club
    Join Date
    2010-10
    Posts
    105
    Login to Give a bone
    0

    Default Re: Formula Help

    " (Area/1) *.2. The 1 effectively divides the area by 1 square meter to make it a number. "

    -----------

    Thank you Dimitri, that is exactly the sort of thing that seems to not be written down anywhere.

    gt

Similar Threads

  1. 2013: How to use this Formula,"Formula That Returns Strings"?
    By mike99 in forum Revit Architecture - General
    Replies: 4
    Last Post: 2013-01-09, 06:28 AM
  2. Yes/No Formula
    By lonewolfjustin in forum Revit MEP - Families
    Replies: 1
    Last Post: 2009-06-05, 12:21 AM
  3. Formula Help
    By stelthorst in forum Style Management
    Replies: 6
    Last Post: 2008-03-25, 05:07 PM
  4. Formula Use
    By jkrager in forum Revit Architecture - Tips & Tricks
    Replies: 0
    Last Post: 2006-01-20, 06:57 PM
  5. = a formula
    By GuyR in forum Revit Architecture - General
    Replies: 35
    Last Post: 2005-03-11, 08:24 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •