Hi there,
Please some one help me with calculation part that i want the respond count or performance of service no's based on CNT(Number of records).
Everyday each service no has to respond 48 times and some service no's are responding more than 48.
My requirement is:
Day wise service no count percentage.(48=100%) More than 48 ....
Month wise service no count percentage(48* Month )
if we select dc no:wdc0001 that dc have 38 service no's which i have shown in sheet in workbook.
if we take dc wdc0001 as parameter then (38*48=1824). i want percentage of count responded for dc on particular day.
and month as well.if we select month.
Thankyou,
surya
