6 Replies Latest reply: Jun 30, 2016 8:21 AM by Sunny Talwar RSS

    Need expression help

    Mark Ritter

      I had asked for help on this before and got some great advice which got me close.


      Here is a rough example of my data.


      Case #        LOS

      1               18

      1               18

      1                18

      2               7

      3               9

      3               9


      So each case can have multiple rows.  But the LOS will always be the same for each record for that case.


      So I need to calculate the AVG LOS for the above group of cases data.  So I would add (18+7+9)/3.  I only want to add the LOS one time for each case.


      I have gotten really close.  But I have some situations where the calculation is not working correctly.


      Any more advice would be greatly appreciated.