Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 )
Try this:
=$(='[' & SubField(Concat(DISTINCT Dim, '|'), '|', 1) & ']')
Try this:
=$(='[' & SubField(Concat(DISTINCT Dim, '|'), '|', 1) & ']')
Cool..
Thanks