Donate Now Goal amount for this year: 3000 USD, Received: 1207 USD (40%)

Results 1 to 5 of 5

Thread: Formula Value Only shows Feet

  1. #1
    New Member
    Join Date
    February 2, 2017
    Posts
    4
    Current Local Time
    12:29 PM

    Formula Value Only shows Feet

    First time posting, Long time reader.

    I have created a formula in my family that takes the width of three separate parameters and calculates the Avg width. The problem I am having is the Value of the Avg width only shows feet and not the inches. Is there a setting I am missing or something I need to add to the formula.

    Sample part of formula for AVG Width
    if(and(and(Accessible Spaces > 1, No Painted Spaces > 1), Compact Spaces = 0), (Accessible Width + Painted Width + Typ Width) / 3

    Attachment shows the result I get.


    Thanks.
    Attached Thumbnails Attached Thumbnails Formula Value Only shows Feet-avg-width..jpg  

  2. #2
    Moderator
    "I am NOT a Revit tutor!"
    Dave Jones's Avatar
    Join Date
    December 7, 2010
    Location
    San Luis Obispo, California USA
    Posts
    4,486
    Current Local Time
    09:29 AM
    Quote Originally Posted by JMDesign View Post
    First time posting, Long time reader.

    I have created a formula in my family that takes the width of three separate parameters and calculates the Avg width. The problem I am having is the Value of the Avg width only shows feet and not the inches. Is there a setting I am missing or something I need to add to the formula.

    Sample part of formula for AVG Width
    if(and(and(Accessible Spaces > 1, No Painted Spaces > 1), Compact Spaces = 0), (Accessible Width + Painted Width + Typ Width) / 3

    Attachment shows the result I get.


    Thanks.
    change the Units in your family to Fractional Inches. Manage/Project Units

  3. #3
    New Member
    Join Date
    February 2, 2017
    Posts
    4
    Current Local Time
    12:29 PM
    Thank you Dave, I did that and that did help. Also notice a error in my formula. Needed to change the 1 to 0.

  4. #4
    Moderator
    "I am NOT a Revit tutor!"
    Dave Jones's Avatar
    Join Date
    December 7, 2010
    Location
    San Luis Obispo, California USA
    Posts
    4,486
    Current Local Time
    09:29 AM
    Quote Originally Posted by JMDesign View Post
    Thank you Dave, I did that and that did help. Also notice a error in my formula. Needed to change the 1 to 0.
    glad you got it worked out!

  5. #5
    Forum Co-Founder Twiceroadsfool's Avatar
    Join Date
    December 7, 2010
    Location
    Dallas, TX
    Posts
    10,035
    Current Local Time
    11:29 AM
    Parking spot row?

Similar Threads

  1. BimBlog: Getting Your Feet Wet
    By BimBlog in forum Blog Feeds
    Replies: 0
    Last Post: April 9th, 2015, 04:45 PM
  2. Feet & Inches Calculator software ?
    By iru69 in forum Out There
    Replies: 30
    Last Post: November 30th, 2012, 05:45 AM
  3. Rounding feet+inches
    By cellophane in forum Architecture - Family Creation
    Replies: 5
    Last Post: July 11th, 2012, 02:25 PM
  4. sheets with different units metric and feet
    By joss in forum Architecture and General Revit Questions
    Replies: 3
    Last Post: March 17th, 2012, 07:34 AM
  5. First Level Not Showing Feet and Inches
    By dzatto in forum Architecture and General Revit Questions
    Replies: 2
    Last Post: July 28th, 2011, 09:01 PM

Posting Permissions

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