7 Replies Latest reply: Feb 8, 2016 6:11 PM by Sunny Talwar RSS

    Mean and Stdev in Straight Tbale

      i am attaching sample excel file and i have, and it is a straight table

      dimension: assignedpcp

      expression1(member count): count(Distinct memnbr)

      expression2(inpatient):  sum(costinpatient)/count(Distinct memnbr)   // [costinpatient also a dimension]


      No i need to write two more expressions :

      mean (86851.43/642=1353) ,[ 642 is count(Distinct Assignedpcp and 86851.43 is the total of column inpatient)]


      stdev .


      The Expected  values of mean and stdev  are in the attached excel sheet.


      Thank in advance