6 Replies Latest reply on Mar 13, 2013 8:51 AM by David Mendel

    Calculating on two date fields

    David Mendel

      I'm trying to calculate a ratio based on two date fields.

      Specifically, I want to calculate the number of bugs created for a given product over the number of bugs fixed for that product in the same month.

       

      I have four columns that need to figure into the calculation Bug ID, Product, Create Date & Closed Date. So for instance if 5 Bug IDs were associated with Product XYZ and had a Create Date in March, and 4 Bug IDs were associated with Product XYZ and had a Close Date in March, I would expect to see a ratio of 1.25 for XYZ in March.