4 Replies Latest reply: Jul 10, 2015 4:35 AM by jagan mohan rao appala RSS

    Average of Distribution percentage

    janardhan reddy

      Hi All,

       

      I have calculated Distribution Percentage and i need avg of distribution percentage. i tried to calculate but the values are not matching.

      (line_srvc_cnt/sum(total line_srvc_cnt)*100) is for Distribution Percentage

      aggr(avg({<[Provider Id]=>}(line_srvc_cnt/sum(total line_srvc_cnt)*100)),[HCPCS Code])  is for Avg of Distribution Percentage

       

      Is there any alternate option to calculate the Average.

       

      Thanks in Advance