3 Replies Latest reply on Mar 22, 2019 9:34 AM by Don Wise

    Create a trailing 12 months calculated feild

    Oscar  Uyamadu

      I am trying to create a calculated field that will give me the trailing 12 and 3 months of the fail rate in my workbook based on each month, so for march 19 i want another column for trailing 12 months and trailing 3 months. the fail rate is simply calculated by dividing failures by deliveries. i am having trouble doing this, please help. The workbook is also attached. Please find the correct workbook attached.