Announcement

Collapse
No announcement yet.

Formula Value Only shows Feet

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    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 Files

    #2
    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
    I'm retired, if you don't like it, go around!

    Comment


      #3
      Thank you Dave, I did that and that did help. Also notice a error in my formula. Needed to change the 1 to 0.

      Comment


        #4
        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!
        I'm retired, if you don't like it, go around!

        Comment


          #5
          Parking spot row?
          Aaron "selfish AND petulant" Maller |P A R A L L A X T E A M | Practice Technology Implementation
          @Web | @Twitter | @LinkedIn | @Email

          Comment

          Related Topics

          Collapse

          Working...
          X