Problem in$ in dimension

[Anonymous]

My field Dim have the following value

if I apply the =$ it will give Error in calculation condition as output but  if I use with it without $ will work fine

=$(=SubField(Concat(DISTINCT Dim, '|'), '|', 1))

Error :Garbage after expression :"Affected"

If I use this ,it will Business affected 1 as Output

=SubField(Concat(DISTINCT Dim, '|'), '|',2 )

[sunny_talwar · Accepted solution]

Try this:

=$(='[' & SubField(Concat(DISTINCT Dim, '|'), '|', 1) & ']')

[Anonymous]

Cool..

Thanks