Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have fields
- A with values 1, 2, 3, 4, 5, 6
- B with values 1, 2, 5
Now I want to create a listbox on field A showing values only that exist in field B.
Once a value in listbox is selected, all other values in B shall still be visible greyed out.
Any idea? Something like
aggr(only({$<=p({1} )>}),)
does not work as listbox formula.
Thx - Marcel
aggr(only({1<=p({1} )>} A),)
Shows the hidden values greyed out as required.
aggr(only({$<=p({1} )>} A),)
is a better try... I missed the A as part of the only function.
aggr(only({1<=p({1} )>} A),)
Shows the hidden values greyed out as required.