5 Replies Latest reply: May 19, 2016 3:54 AM by Daniel Mann RSS

    12 Month Rolling

    Daniel Mann

      Hi Guys,

       

      I know that this has been asked many many many times before, but I can't figure out how to do it using a calculation in stead of a single field.

       

      I need to display a 12 month rolling avg for LTIF on a chart, but the following is not working.

       

      Any suggestions where I am going wrong?

       

      rangeavg( above(sum({<[Accident Category]={'Fatal','Permanent Total Disability (PTD)','Permanent Partial Disability (PPD)','Lost Workday Case (LWC)'}>}[Crew])

      /

      sum([Total Crew Days]*24)

      *

      1000000),0,12)