Match Function Error

[#1]

Hi Friends,

I am using the code Mathc(xxx,01,02,03)  to get values related to only 01, 02 and 03 respective.

But its alos giving values related to 00 also.

Should I add anything to remove 00 from filters.

Thanks

Pavan

[alexandros17]

Try with this:

match(xxx,'01','02','03')

let me know

[#3]

Thanks for response

Still its not working

[alexandros17]

Try with wilmatch instead of match and let me know

[#5]

No still showing the same

[MarcoWedel]

How do you use this function (in which context)?

Match(xxx,01,02,03) will return 0 indeed, if there is no matching value. Maybe that's the reason for getting/matching 00, when actually there is no match.

hope this helps

regards

Marco

[#7]

Hi Wedel,

I am using this in a pivot table for caluculated dimention. XXX is one my dimention.

I want to see only records matching 01 and 02 in the pivot table. I used the function num(xxxx,00) while loading. and num(match(xxxx,01,02),00) in caluculated dimention.

But here I am getting 00 values also.

Thanks

Pavan

[MarcoWedel · Accepted solution]

like I thought. Match returns 00 not because it could match to this value, but because it couldn't match any value and therefore returned 0.

Use

If(match(xxxx,01,02),xxxx)

instead

hope this helps

regards

Marco

[jyothish8807]

Hi Pavan,

Try like this:

If(match(xxxx,01,02)>0,XXXX)

Hope it works.

Regards

KC

[#10]

Thanks Wedel

It works  But one more problem. I added another field 'Agent Number' which is a primary key.

I am geeting all the values of primary key into pivot table.

I want 'Agent Number' into piovt table only if XXX is equal to 01 and 02.

Thanks

Pavan