RE:Multi select

[Chanty4u]

hi all,

tresesco

swuehl

Marco Wedel

i have two multi box ....and one stright table

level2   and def-seviority

prj1                    critical

prj2               major

prj3               minor

lik dat i hve.... when i select  in prj1 and    critical and minor   from both the multiboxes...... i need extra colum in pivot table  as

sum of the both selcted critical and minor as well...total count of  prj1 ?

how can i achieve this?

thanks in advance 

Suresh

[Anonymous]

did nt get you...

What exactly you want? could u explain more?

[Chanty4u]

i hve table like dis

Table: 

LOAD * INLINE [ 

    Sample 

    dotnet 

    dot 

    dotnet123 

]; 

how to find exact match in that ?

[karthikeyan1504]

‌getfieldselection(fieldname)

[Chanty4u]

not working

[Anonymous]

what about match()??

match(Sample,'dotnet','dot','dotnet123')

[karthikeyan1504]

What output are you getting when u try this function text box?

[Anonymous]

see this..

Match() is used for a case sensitive comparison. It matches the exact searchstring you pass in the function.

for Example: Match(Name,'Raja') , returns true if a person's name is exactly Raja (R caps).

WildMatch is used for a match where a string can be part of the search string.

For example :Match(Name,'Raja') will return true if a person's name is Raja, Maharaja, Rajan, or Rajat or some other string containing Raja in it.

MixMatch is same as Match but it is case insensitive.

[Chanty4u]

for example..

i hve  one list box....wit below values.

brandcode

cognos brand code

mynumber

if i will use substring count to find  brandcode alue it will return 2

dat i dnt want

i want exact.match only..

[Anonymous]

may be like this?

=if(Match(YourFiedl, GetFieldSelections(YourField)),'Matching','NotMatching')

[tresesco]

Count({<Field={'brandcode'}>} Field) ?