8 Replies Latest reply: Feb 4, 2016 8:24 AM by Chirag Perla RSS

    Mean and Stdev

    Johnamos daram

      i am attching 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 of expression 2(inpatient)

      and

      stdev of expression2(inpatient).

       

      Thank in advance