Adhoc Reporting - Measures

[tmumaw]

Does anyone know why would both R&M and % R&M come out together when I only select  % R&M ?  I am working off the _metrics. How can I control only to have R&M % to come up.

MetricsOptions:

LOAD * INLINE [_metricsNo, _metrics

1, LID,

2, Fuel

3, R&M

4, Total Costs

5, Billed Hrs

6, Std Hrs

7, Util %

8, No Units

9, Avg Cost

10, Billed

11, R&M %

12, Fuel %

];

=SubStringCount(Concat(_metrics, '|'),'R&M')

=SubStringCount(Concat(_metrics, '|'), 'R&M %')

[sunny_talwar · Accepted solution]

Try it like this for all your measures

=SubStringCount(Concat(DISTINCT '|' & _metrics & '|', ','),'|R&M|')

[tmumaw]

Thanks Sunny T.......Works perfect.