Calculated dimension problem

[sarfaraz_sheikh]

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

[amit_saini]

Hi,

This might help u:

How to rename my Pie-Chart Values?

Thanks,
AS

[jonathandienst]

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

[#4]

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

[#5]

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')))

[sarfaraz_sheikh]

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

[sarfaraz_sheikh]

Kindly reply its urgent !!!!!!!!!!

Sarfaraz

[jonathandienst]

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

[sarfaraz_sheikh]

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

[simsondevadoss]

Pls check the option show total in dimension limits.

PFA