Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
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)))
May be this?
=Only({1} if(LinkedAccountId='123',trim(subfield(subfield(ItemDescription, 'Sign up charge for subscription: ', 2),',', 1))), ItemDescription)
What is your expression? I think you need to use set analysis in your expression. Assuming it is Sum(Measure), change it to Sum({1} Measure)
This is my expression.
=if(LinkedAccountId='123',trim(subfield(subfield(ItemDescription, 'Sign up charge for subscription: ', 2),',', 1)))
I'm not trying to calculate sum or any calculation. Want to have it as my dimension.
May be two options over Front End
1) Lock the Field
2) Read only option
That only works in the local edition, but not the server edition.
Hi Samuel,
try this:
=mid(
Only( {1 < LinkedAccountId= {'123'} >} ItemDescription) 1,2
)
where 1 and 2 are parameters of mid function.
Where exactly are you trying to do this? In a chart? What is the dimension and what is the expression? Would you be able to share an image to clarify what you have? or a sample may be?