i'm attaching my workbook. In that sheet1 (AMI Count) in this i'm showing the count of service no's based on dc selection.Per one day for every service number we will get 48 records (24hours*2) .
in total meters under dc Page we have total meters under one dc.
example:
For Wdc0001 we have 38 services 38*48=1824 records per day.
My Requirements:
i want the percentage count of serviceNo per day based on dc selection.
i want month wise percentage as well.
For example if i select wdc0001 for December month then 38*48*31=56,544 Records
that should be shown in percentage based on the response count.
Thankyou.
Hi Suresh Pusuluri,
I think your calculation might not be correct for AMI-Count. Reason behind this is your current calculation is depends on which time user opens report as you have used NOW() in calculation. So there might be possibility your percentage can exceed to 100% that totally depends on when user opens report.
You can find attached workbook to check percentage calculation of daily and as of i know percentage would be same for day or month as per your calculation.
Please find attached workbook for percentage logic. Let me know if this not what you're looking for then explain in brief about your data and calculation logic.
Thanks,
Dishant Shah
