SubStringCount function issue

[vikasmahajan]

Dear all,

I have  inline load and loading dimensions into table , and applying  =SubStringCount(Concat($Field, '|'), 'Level 4 Mgr Name')

it giving me zero o/p but it should give 1 for ad-hoc reporting.

QVW is attached .

Base on selection in list  o/p should  0 /1

Thanks

Vikas

[vikasmahajan]

Thanks Both

[settu_periasamy]

Yes. We can simplify like..

=Alt(WildMatch(GetFieldSelections(dimension_1, '|',100), '*Level 4 Mgr Name*'), 0 )

[vikasmahajan]

Thanks sunny actually  you are right if will create a performance issue.

Vikas

[sunny_talwar]

My response seem to go removed, but won't the WildMatch give -1 when the statement is true? We might need to multiply the whole things by -1 to get positive 1?

=Alt(WildMatch(GetFieldSelections(dimension_1, '|',100), '*Level 4 Mgr Name*'), 0) * -1

But I somehow still like using SubStringCount(). My personal preference

[settu_periasamy]

The wildmatch  part giving the value '1'. So, i think we don't want to mutiply by -1

[sunny_talwar]

Right, I got it confused with the if. Sorry about that