15 Replies Latest reply: Oct 24, 2014 7:52 AM by pavan Kumar

# Match Function Error

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

• ###### Re: Match Function Error

Try with this:

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

let me know

• ###### Re: Match Function Error

Thanks for response

Still its not working

• ###### Re: Match Function Error

Try with wilmatch instead of match and let me know

• ###### Re: Match Function Error

No still showing the same

• ###### Re: Match Function Error

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

• ###### Re: Match Function Error

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

• ###### Re: Match Function Error

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)

hope this helps

regards

Marco

• ###### Re: Match Function Error

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

• ###### Re: Match Function Error

Hi Pavan,

Try like this:

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

Hope it works.

Regards

KC

• ###### Re: Match Function Error

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

• ###### Re: Match Function Error

Hi Pavan,

In dimension write:

Only({<XXXX={01,02}>}Agent Number)

Regards

KC

• ###### Re: Match Function Error

The Problem is Its not displaying 00 but displaying balnks instead.

• ###### Re: Match Function Error

Then do this:

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

Regards

KC

• ###### Re: Match Function Error

Hi Wedel/Jyothish

Thanks

My problem solved.

• ###### Re: Match Function Error

Hi Wedel,

I used If(match(xxx,01,02),xxx). Now all the values which are not matching are gouped into one and giving me total at the last row as blank total.

I dont want any of the non-matching values.

Thanks