topic Re: Invalid Lookup Formula in Revit MEP Forum

Invalid Lookup Formula

Anonymous — Mon, 25 Mar 2019 19:37:43 GMT

This formula is reported to me as invalid and I was asked by Revit to either change formula or use correct lookup table:

= size_lookup(Lookup Table Name, "SWid", (Nominal Diameter) * 0.6, Nominal Diameter)

From what I learned so far, I cannot find anything wrong with this formula, it looks as all other formulas of this type. SWid column does exist in my lookup table, so it's really a mysterious to me what is wrong.

Re: Invalid Lookup Formula

talalaevd — Tue, 26 Mar 2019 08:00:43 GMT

Need screenshot window with parameters and types.

Re: Invalid Lookup Formula

Anonymous — Tue, 26 Mar 2019 11:46:01 GMT

Here it is, hope this is sufficient:

Re: Invalid Lookup Formula

talalaevd — Tue, 26 Mar 2019 13:08:24 GMT

Ok.

What is the value for parameter "Lookup Table Name"? What lookup tables loaded in family? Manage Lookup Tables button.

Is type "Standart" only one in this family? Maybe another types exist?

Re: Invalid Lookup Formula

Anonymous — Tue, 26 Mar 2019 13:48:14 GMT

Your questions move things forward, but Revit is still rendering resistance.

So:

1- there are no other parameters by "Standard" ones

2- lookup table name:

I thought that "manage lookup tables" command handles name automatically, but it seems to not be the case.

In fitting settings, table name is "Pipe Combination Wye with 8th Bend - Glued"

In Excell file the name is "M_Pipe Combination Wye with 8th Bend - Glued".

I added this prefix manually in fitting settings, and "invalid formula" error disappeared.

However, the story continued when I saved and reloaded family. I got this:

Trying to use this fitting, "no lookup table" error continued.

Now things become funnier: when I went back to check my fitting via "edit family", the prefix that I manually put in Lookup Table Name ("M_") disappeared!

I tried it several times and every time I try to reload modified family into the project, my manual correction of lookup table name disappears and things are moved back to beginning...

Re: Invalid Lookup Formula

Anonymous — Tue, 26 Mar 2019 13:56:19 GMT

Oh sorry, the first image in my last message is wrong, new error is:

Re: Invalid Lookup Formula

talalaevd — Tue, 26 Mar 2019 15:28:23 GMT

1. For use size_lookup formula you must have loaded file with lookup table.

So first of all did you have loaded file? Screenshot with Lookup table manager.

Re: Invalid Lookup Formula

Anonymous — Tue, 26 Mar 2019 16:13:07 GMT

I have it loaded, but, as mentioned, name of lookup table changes by itself within fitting settings, despite my interventions, and always revert to the same name whatever I do.

Now, though, I think that solution is found, at least for now: I changed csv file name of lookup table to match that unchangeable name in fitting settings, and now it seems to be working.

Re: Invalid Lookup Formula

talalaevd — Tue, 26 Mar 2019 16:37:42 GMT

Take a look at it just in case.