Explanation?

[Anonymous]

Hi..

Can you please give a explanation about following expression.

   =SubStringCount('|' & Concat(distinct %ExpressionName, '|') & '|', '|Total Sales|')

[MK_QSL]

Similar to this.... except the Concat and Search String are having '|' at the start and end...

Função: SubStringCount

[anbu1984]

SubStringCount - Returns the number of times the string substring('|Total Sales|') appears within string ('|' & Concat(distinct %ExpressionName, '|') & '|').

Concat(distinct %ExpressionName, '|') - Returns distinct aggregated ExpressionName

[Anonymous]

Hi anbu..

Thank you for your reply....

In Concat(distinct %ExpressionName, '|')

   Distinct %ExpressionName returns distinct values of %ExpressionName.

  But I can't understood about  '|' and Concat(distinct %ExpressionName, '|').

Can you please explain in detail.....

Thanks & Regards,

chandini.G

[anbu1984]

Concat(distinct %ExpressionName, '|')

If %ExpressionName has only one value say 'Total Sales',

Concat(distinct %ExpressionName, '|') returns 'Total Sales' without Pipe

If %ExpressionName has three values say 'Total amount', 'Total Sales' , 'Total value'

Concat(distinct %ExpressionName, '|') returns Total amount|Total Sales|Total value

So '|' beginning and end of Concat, so we can use '|Total Sales|' to get substring count.

[Anonymous]

Hi Anbu..

  Thanks for your reply...

Its Helpfull for me...........

Thanks & Regards,

Chandini.G