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)