Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am using match function in straight table(in add calculated dimention).But my match function is not properly working as per my condition.
Straight table dimention>add calculated dimetion
=if(CPC_CODE='C473','XYZ',
if(CPC_CODE='C430','pqr',
if(match(CPC_CODE,'C4241'),'A',
if(match(CPC_CODE,'C423'),'B',
if(match(CPC_CODE,'C4301','C4302'),'C',
if(match(CPC_CODE,'C4301','C473','C4302','C430','C473'),'D'
))))))
Result is showing
XYZ
pqr
A
B
C
but not showing D.I want to show all condition.
Because in match function for D : CPC_CODE =4310 and 4302 is repeating as we have used CPC_CODE =4310 and 4302 in match function for C.So Match function is not working where CPC_CODE already used in other case.Pls tell what i have to do.Or there is any other function to solve this??
I am making a group of cpc_code, so with these group condition i will produce a name.
if(cpc_code 4301 and 4302 - i want
cpc group value
A 30
Now I notice, you want single member to be part of seperate groupings. For this you have to work in the script; kind of generic association for some members. Try to upload your sample app with sample data, would be easier to help you.