Hi,

I have created a summary report where I have grouped the values based on Account name.

The main requirement is to find the precentage of accounts which have used atleast one case

Here when I am trying to group using accounts so that my report will look like

Account name(XXXX)(2 records)

       Case number        Case used

          YYYYY                          1

           YYYYY                          1

Account name(ZZZZ)(2 records)

       Case number        Case used

           AAAAA                         1

           AAAAA                          1

Now two account have used atleast 1 case. There may be accounts without using cases also. In that case how can I get the number of accounts those who used a single case.

if 2 among 3 accounts used cases then I need a percentage 2/3 = 66.67%

How to make this possible?

Regards,

Sai