SubStringCount wrong display

[Anonymous]

Hi All

In attached example I want to see actual quarter like 'Q4-14' etc rather than stupid values. Can somebody help me please?

In Red is not sorted

Instead of 20,3,3,5,4 I need Q4-14, Q1-15 and so on

Thanks

[sunny_talwar]

Use this instead:

='1 is:  ' & SubField(Concat(Values, '|', Qtr), '|', 1)

HTH

Best,

Sunny

[sunny_talwar · Accepted solution]

Attaching your application for reference also.

Best,

Sunny

[MK_QSL]

='1 is:  ' & SubField(Concat(Values, '|',Qtr), '|',1)

='2 is:  ' & SubField(Concat(Values, '|',Qtr), '|',2)

and so on

[JonnyPoole]

in addition to above, you may also need  DISTINCT clause in concat:     concat(  distinct   ....  )  so that the values don't repeat for every row of data.