How to calculate conversion ratio

[aparnawangu]

Hi Team,

I have a table called Enquiry_Form and i want to calculate the enquiry conversion ratio for 10 centres.
The fields in the table are Enquiry_Form_No,Enquiry_Date and Centre_Name.
For eg like 10 enquiries came for W1 centre but converted only 5 so that ratio i need.

How to do that?Pls help me .

Regards


Aparna Wangu

[June7]

What determines that an enquiry is 'converted'?

[aparnawangu]

What determines that an enquiry is 'converted'?

We will gather info like no of enquiries for the month or week as per requirement and then we will check the admissions happened for that period so accordingly we can calculate the conversion ratio for that particular centre.

I need to see the conversion ratio for all the centres from W1-w10 in one single view.

Pls help me out.

Regards
Aparna

[June7]

Doesn't really answer my question. What identifies a record as 'converted'? What field and what value flags a record as 'converted'?

What you want will likely involve aggregate (GROUP BY) Totals query. To be more specific I would have to know your data structure and relationships. If you want to provide db for analysis, follow instructions at bottom of my post.