I want to have a detached table, but the server option does not support it. I think the workaround is to use set expression. But so far, I have not been able to make it work. Here's my requirement. I need to extract a portion of string from a field named "ItemDescription" and when LinkedAccountId is 123. Below is the original expression. But I need it to be "detached" disregard any selection.
=if(LinkedAccountId='123',trim(subfield(subfield(ItemDescription, 'Sign up charge for subscription: ', 2),',', 1)))