2 Replies Latest reply on Sep 19, 2013 10:06 AM by Matt Lutton

    Calculation help please

    Eric Hansen

      I have a crosstab where in the first two columns, I am summing values of fields by project size.

       

      Column 1= sum of planned cost

      Column 2= sum of cost differenc ebetween planned and actual

       

      In column 3, I need to divide the result of column 2 by the result of column 1 for each row.

       

      I have been unable to do this with a calculated field or table calculation.

       

      How do I get this result?