1 Reply Latest reply: Nov 25, 2013 4:18 PM by Mehmet Çaldak RSS

    Calculate Median


      Hello all,

       

      I am having hard time to calculate median time using expressions. I need to put some specific criteria in place for getting my median value.

       

      Here is what I am trying to do:

      Referral id        *RFI date      *RFI Response Date        RFI date – RFI Response                  SUM

      101                  Mar 10        Mar11                                              1                                     1

      102                  Feb 5          Feb 7                                               2                                 

      102                  Apr 3          Apr 5                                                2                                     4

      104                  Jun 4          Jun 7                                                3                                     3

       

      At the end median = {1,3,4}=3

       

      * RFI date: Request for information

      * RFI Response Date: Information sent back

       

      Based on this example I get number of days between RFI Date and RFI Response Date and I get sum of these dayes per referral.

      My problem is I don't know how to calculate the SUM group by referrals as an expression without changing the data model.

       

      I appreciate if you share your exprience on that.

       

      Thank you,

      Behnaz