Announcement

Collapse
No announcement yet.

Lookup Table Using Number

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
    #1

    Lookup Table Using Number

    Been reading the forum for a while but first time posting.

    I am wanting to add Weight and Volume to a family through existing lookup table. I know I cant add the Weight so was trying to use number then convert the units in family. Added Parameter in family and in lookup but constantly receive inconsistent units error.
    Have tried the suggestions found in forum but nothing seems to be working.
    ItemWeight##Other
    ItemWeight##Other##number
    ItemWeight##Number
    ItemWeight##Number##Other

    Tried changing case but not having luck.

    size_lookup(Lookup Table Name, "ItemWeight", 0', Nominal Diameter, BendAngle)

    Am I missing something simple here.

    Thanks
    Tags: None
    #2
    "welcome" to the forum Tom! :thumbsup:

    It's not <Item Weight> as a Number parameter giving you the problem, but the fact <Nominal Diameter> will be a Length, and <BendAngle> will be an Angle.

    You can't (not without some maths) mix data types.

    Comment

      #3
      http://revitforum.org/tutorials-tips...lize-them.html ;-)
      Klaus Munkholm
      "Do. Or do not. There is no try."

      Comment

        #4
        Originally posted by snowyweston View Post
        "welcome" to the forum Tom! :thumbsup:

        It's not <Item Weight> as a Number parameter giving you the problem, but the fact <Nominal Diameter> will be a Length, and <BendAngle> will be an Angle.

        You can't (not without some maths) mix data types.
        Thanks Snowy. You may be correct although similar lookup is working elsewhere in the family

        size_lookup(Lookup Table Name, "PipeOD", 0', Nominal Diameter, BendAngle)

        Although in this instance I am trying to return a number value.

        Comment

          #5
          Originally posted by Tim_Ea View Post
          Although in this instance I am trying to return a number value.
          And I confused "lookup" for "formula" and should probably step-back because MEP's not my thing! :hide:

          Comment

            #6
            Thanks Snowy. It is easy to mix them up.

            I have been able to resolve the issue. Within the lookup table you use the ParameterName##other##number format for the header. The error came from copy and paste of the lookup formula.

            size_lookup(Lookup Table Name, "ItemWeight", 0', Nominal Diameter, BendAngle)

            Having the feet in the Default if not found returned inconsistent units regardless, Once removed I was able to use this with number. Although in the end I used ItemWeight##mass##pounds used the availability for the number.

            Comment

            Previous template Next

            Related Topics

            Collapse
            Working...
            X