
Anonymous
Not applicable
2017-02-28
06:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Problem in$ in dimension
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 )
473 Views
1 Solution
Accepted Solutions

MVP
2017-02-28
06:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this:
=$(='[' & SubField(Concat(DISTINCT Dim, '|'), '|', 1) & ']')
434 Views
2 Replies

MVP
2017-02-28
06:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this:
=$(='[' & SubField(Concat(DISTINCT Dim, '|'), '|', 1) & ']')
435 Views

Anonymous
Not applicable
2017-02-28
06:12 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Cool..
Thanks
434 Views
