Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.

Lookup Tables with currency

Joos_T
Enthusiast

Lookup Tables with currency

Joos_T
Enthusiast
Enthusiast

I was wondering if it's possible to automaticly change prices ("Cost" parameter) in my revit familie with a lookup table.  I've been searching for the right parameter type and parameter unit but not able to find the right one for my excel sheet. Revit keeps saying inconsistent Units. I've tried:

##CURRENCY#

##NUMBER##GENERAL

##NUMBER##CURRENCY
##OTHER##

##OTHER##CURRENCY

 

Maybe one of you can help me.

 

Thanks a lot!

 

 

 

 

 

0 Likes
Reply
Accepted solutions (1)
1,984 Views
14 Replies
Replies (14)

iainsavage
Mentor
Mentor

From the help for  lookup tables:

“Acceptable parameter types are: NUMBER, LENGTH, AREA, VOLUME, ANGLE, and OTHER.

For example, a column may have the following header: TotalArea##AREA##INCHES to represent the total area in square inches.”

 

But from the help for type catalogues:

The following table includes a sample of the types of parameters supported in a type catalog. 

Type of Parameter Parameter Declaration Notes
Textparam_name##OTHER## 
Integerparam_name##OTHER## 
Numberparam_name##OTHER## 
Lengthparam_name##LENGTH##FEET 
Areaparam_name##AREA##SQUARE_FEET 
Volumeparam_name##VOLUME##CUBIC_FEET 
Angleparam_name##ANGLE##DEGREES 
Slopeparam_name##SLOPE##SLOPE_DEGREES 
Currencyparam_name##CURRENCY## 
URLparam_name##OTHER## 
Materialparam_name##OTHER## 
Yes/Noparam_name##OTHER##Defined as 1 or 0 with 1 equaling Yes and 0 equaling No.
<Family Type>param_name##OTHER##Family name:type name with no file extension

 

So it looks like Currency is not a valid parameter type in a lookup table but can be used in a type catologue.


For your example therefore, in a lookup table, I think you would use NUMBER without any units so something like GBP_Price##NUMBER##

 

Joos_T
Enthusiast
Enthusiast

Thanks for your reply.

 

I tried to use Price##NUMBER## without any units but it doesn't work. 

I've also tried to use Cost##NUMBER##GENERAL and a family parameter with parametertype "number" but this doesn't work. 

 

The only way it seems to work is using Cost##Other## and a shared parameter with "text" as parametertype. 

 

For the type catalog,  I can not use this in Piping because it will not automaticly select the right type. 

With this lookup table I can draw with the piping tool and it will automaticly search for the right article numbers, discriptions and other values. 

 

0 Likes

iainsavage
Mentor
Mentor

Apologies, it should be <parameter>##NUMBER##GENERAL

I’ve tried it and it does work.

When you say that Cost##NUMBER##GENERAL didn’t work, what error did you get?

Joos_T
Enthusiast
Enthusiast
The error I get is "Inconsistant Units".
What kind of parameter type do you set for your parameter? I'm using the type: Number.
0 Likes

Joos_T
Enthusiast
Enthusiast

I've made a sample file so you can see how I build it. 

Maybe it's something in the properties or with the units because i'm using the metric system.

 

As formula for Price I use: size_lookup(Lookup Table,"Price", "Not Found", Length) 

 

Thanks in advance.

0 Likes

iainsavage
Mentor
Mentor
Accepted solution

The Inconsistent Units message is not because of the Price parameter, its the Length which is causing the error. It is corrected by dividing the Length by 1mm.

Also, I'm pretty sure that you can't just have text in the formula to act as your error message - you need to assign a value and then call up another parameter (using IsCustom?).

@fabiosato or @L.Maas or @robert.klempau would be able to help you with the correct syntax for this.

iainsavage_0-1638537525156.png

 

0 Likes

Joos_T
Enthusiast
Enthusiast
The error message was the problem!
Now it's solved. I can add the number to the cost parameter. Dividing by 1mm was not necessary.

Thanks a lot!
0 Likes

tranduylinh1995
Explorer
Explorer

Can you show lookup table 

I cant make this. 

0 Likes

Joos_T
Enthusiast
Enthusiast

Joos_T_0-1653901532535.png

 

0 Likes

tranduylinh1995
Explorer
Explorer

can you show me this formula? I cant make it. thankyou very much

tranduylinh1995_0-1653902069343.png

 

0 Likes

Joos_T
Enthusiast
Enthusiast

Do you know how a lookup table works?

 

Here is some basic information:

https://knowledge.autodesk.com/support/revit/learn-explore/caas/CloudHelp/cloudhelp/2018/ENU/Revit-C...

 

0 Likes

Vuxvix
Advocate
Advocate

Hi! I trying control materials via Look up Table. but showing error:"This parametter type cannot be defined by formulas"

So follow @iainsavagelist above: 

Materialparam_name##OTHER##

What to do!?MatbyCSV.PNG

0 Likes

iainsavage
Mentor
Mentor

If you read my post correctly that list was valid for Type Catalogue entries.

The shorter list above it is the one for lookup tables.

Maybe the reason that there's a shorter list for lookup table headers is because some parameters can't be used in formulas?

Vuxvix
Advocate
Advocate
Thanks for the useful information.
0 Likes