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

 

[arnelgp]

how do you calculate the conversion?

 

[aparnawangu]

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