Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear ALL,
I have one column called as ' STATUS_ID' having following contents....
(75,77,78,80,82,87,91,93,94,100)
I am taking this in calculated dimension.like below
if(Wildmatch(STATUS_ID,80),'Insurer_Reject',if(Wildmatch(STATUS_ID,75),'Follow_Up' , if(Wildmatch(STATUS_ID,75,80),'Sales_Closed_Final')))
I am getting Insurer Reject and Follow_up as dimension content however i am not getting sales_closed_final in dimension content
What can be the reason ? ..........Is something i am doing wrong.....If it is possible then how i can do this
Kindly help
Sarfaraz
Hi
Because Sales_Closed_Final uses the same values of STATUS_ID in your expression as the other two (75,80).
This can be more efficiently written:
Pick(Match(STATUS_ID, 80, 75, xx), 'Insurer_Reject', 'Follow_Up' , 'Sales_Closed_Final')
(replace xx with the correct code for Sales_Closed_Final)
HTH
Jonathan
Hi
Final'
=if(Wildmatch(STATUS_ID,80),'Insurer_Reject',if(Wildmatch(STATUS_ID,75),'Follow_Up' , 'Sales_Closed_Final'))
this might helps you if any comes expect 80,75 remaing things will for 'Sales_Closed_Final' category
Please find my attachment
Hi
This also give appropriate result
=if(Wildmatch(STATUS_ID,80),'Insurer_Reject',if(Wildmatch(STATUS_ID,75),'Follow_Up' ,if(STATUS_ID>75 and STATUS_ID<80, 'Sales_Closed_Final')))
Dear jonathan,
there is no any specific code for Sales_closed_final. It is calculating by the combination of Insurer Reject and Follow_up code i.e 80 and 75 respectively.
Sales_closed_final=80+75 likewise
Is it possible ...if yes then how i can do this .......Please reply !!!!!!
Sarfaraz
Kindly reply its urgent !!!!!!!!!!
Sarfaraz
Sounds like a hierarchy:
Status - 75/80 'Closed'
Reason - 75 'Insurer_Reject', 80 'Follow_Up'
...
If(Match(Status, '75', '80'), 'Closed', 'Open) As Status1,
PIck(Match(Status, 75, 80), 'Insurer_Reject', 'Follow_Up') As Reason,
...
HTH
Jonathan
Dear Jonathan,
75 - Insurer reject containas value 20
80 - Follow_up contains value 30
75,80 - Sales_closed_date will contains the value 50 ...
The above is my requirement .........kindly look over the same ...
Sarfaraz
Pls check the option show total in dimension limits.
PFA