Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Try with this:
match(xxx,'01','02','03')
let me know
Thanks for response
Still its not working
Try with wilmatch instead of match and let me know
No still showing the same
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
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
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
Hi Pavan,
Try like this:
If(match(xxxx,01,02)>0,XXXX)
Hope it works.
Regards
KC
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