Lookup Tables with currency

[Joos_T]

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!

[iainsavage]

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

Text	param_name##OTHER##
Integer	param_name##OTHER##
Number	param_name##OTHER##
Length	param_name##LENGTH##FEET
Area	param_name##AREA##SQUARE_FEET
Volume	param_name##VOLUME##CUBIC_FEET
Angle	param_name##ANGLE##DEGREES
Slope	param_name##SLOPE##SLOPE_DEGREES
Currency	param_name##CURRENCY##
URL	param_name##OTHER##
Material	param_name##OTHER##
Yes/No	param_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]

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. 

[iainsavage]

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]

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

[Joos_T]

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.

[iainsavage · 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.

[Joos_T]

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!

[tranduylinh1995]

Can you show lookup table 

I cant make this. 

[Joos_T]

[tranduylinh1995]

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

[Joos_T]

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...

[Vuxvix]

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

So follow @iainsavagelist above:　

Material

param_name##OTHER##

What to do!?

[iainsavage]

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]

Thanks for the useful information.