Search in Listbox with Formula as Dimension

[chrweber]

How do I search advanced in a Listbox with a user defined dimension (via formula).

[chrweber]

i wish to restrict the list using if

[marcus_sommer]

What doesn't work with your approach? This within the example worked:

- Marcus

[sunny_talwar]

But here the fieldA is never equal to x... so it will show all the FieldA.... if you do this =if([FieldA]<>'a', [FieldA]) I see only b and c....

but was this what you were trying to do? or were you doing a advanced search?

[chrweber]

Please try searching for 1 in the listboxes.

the x is without effect but to have a valid if

[sunny_talwar]

The advanced search window doesn't even open up for a calculated dimension in list box....

[chrweber]

Hence this thread

[marcus_sommer]

In my opinion this couldn't work by the design of this feature which is a search in fields by running through all (enabled) fields respectively system-tables. And the calculated dimension is not a field there ... This meant you need to create this field within the script.

- Marcus