8 Replies Latest reply: Aug 23, 2013 9:27 AM by Bruno Santos RSS

    Set Analysis and concat

    Gordon Savage

      Hi all,

      I have a chart expression:

      sum({1<[Ordering Depot]={'$(=concat(distinct Depot))'}>} [Number Orders])

      but this always (incorrectly) returns 0

      I am using the dollar-sign expansion so that it returns the results of the concat in single quotes as 'Depot' is a text field which may contain spaces.

      If I create a chart and put any of these expressions into it:

      =concat(distinct Depot)
      $(=Year(Today()))
      $(=concat(distinct Year(Today())))

      they return the expected values but if I try

      $(=concat(distinct Depot))

      it returns nothing.

      I am obviously missing something, but what?

      Any help appreciated.

      Gordon