Error de unidades incoherentes en formula con tabla de consulta

[Lautaro_S_B_]

Hola, estoy haciendo una familia de válvulas, asigné unos parámetros, creé una tabla de consulta, la importé y ahora no puedo crear las fórmulas porque me salta el error "Unidades incoherentes". No se si es algo de la tabla que armé y debo corregir en Excel o es algo con mi fórmula. A continuación adjunto imagen de la fórmula y la tabla CSV por si encuentran mi error ahí.

Nota: en la tabla tengo mas parámetros de los que se ven en la imagen de la familia pero es porque al no poder ni completar una fórmula no creé los demás.

Nota 2: si este post aparece en la sección o idioma incorrecto, por favor corregirlo.

Gracias!

[iainsavage]

https://www.autodesk.com/support/technical/article/caas/sfdcarticles/sfdcarticles/Inconsistent-units...

The units created by the formula have to match the units for the parameter, for example length parameter will be looking for mm

[Lautaro_S_B_]

mmm... All my units are in milimeters (up to what I know) and I'm just using a table, not any other operation...
I still can't visualize what's going on...

[iainsavage]

It is probably the use of text in the lookup formula which is causing you problems.

There have been other posts on this before.

https://forums.autodesk.com/t5/revit-mep-forum/inconsistent-units-size-lookup/m-p/11230258

I think you need to use an extreme value as the not found condition, for example 0mm or a very large value which forces an error in the family. Then you can use another formula to issue a warning and maybe show a warning symbol in the family if the diameter equals the "not found" value.

[reylorente1]

Hola,me parece que al final de la formula debes multiplicar por 1000 mm.Aqui te muestro una imagen,donde de una tabla excel(cvs),extraje la longitud equivalente de esta pieza(Codo).espero que te ayude.

[reylorente1]

Sorry, the answer was for Lautaro_S_B

[iainsavage · Accepted solution]

I'm pretty sure that it is this [art which is causing the problem because A is looking for a number with units of mm, not a text string.

See the link in my earlier answer which links to @fabiosato 's answer to a previous similar post.

[iainsavage · Accepted solution]

Here's an example of how Geberit do it, using excessively large values if the diameter or angle are "not found" .