6 Replies Latest reply on Dec 20, 2016 8:23 AM by Gene Denny

    Difference of Two Columns as a Calculated Field

    Gene Denny

      Given the attached workbook, I would like to create a third column (that will actually be used for other purposes later in the project) which is simply Column A - Column B.

       

      Column A (2015) is a table calculation showing Percent of Total Across for the testing date of 3/31/14 and I have hidden the Not Proficient column.

       

      Column B (2014) is a table calculation showing Percent of Total Across for the testing date of 3/30/15 and I have hidden the Not Proficient column.

       

      The third column currently shows the Sum of the Columns A and B by using the Show Row Grand Totals command.  For the Downtown row, I'd like this third column to be 44.40% - 43.60% or 0.80%.  However, I need this to actually be a calculated field that I drag to the Columns shelf.

       

      So, I guess my real question is, "How do I create a calculated field that shows the difference of the two columns?"

       

      Appreciate any help you can all give!