Hi,

 

I’ve got the following information to process, it correspond to the numbers of tecnhical  incidents/cases closed at first contact, for each dimension (day, problem, service type)

 

DAY                       SERVICE TYPE    PROBLEM_ID   TOTAL_INCIDENTS    FIRST CONTACT     % FIRST CONTACT          

2008-01-02         STD                        1                             17                                        6                                       0.352                                        

2008-01-02         STD                        10                           5                                          3                                       0.600                                     

2008-01-02         STD                        5                             20                                        13                                     0.650                             

 

 

I need to build a chart and a cross-tab tab   to show the % of first contact for each Day

 

In the above case this value should be 0,5238   (6+3+13 / 17+5+20 ), however when I build the table , I’m not being able to get this value.

 

In both cases if I choose my summarized field to be the average of   "%Firstcontact" field , or if i create a calculated formula field  (FIRST CONTACT / TOTAL_INCIDENTS), I get a different value of 0,5238    because crystal do the average of (0,352   and 0,6 and 0,65    = 0,534)

 

 

How could I get crystal to do the math that I need ?

Even so, the values are diferent (0,5343 and 0,5238), i don't think this is a decimal issue