8 Replies Latest reply on Oct 19, 2012 10:41 AM by Kevin Sullivan

    Dividing one column row by next column one row down

    Kevin Sullivan

      Is there a way to create a calculated field that would divide the “Sum of Customers” by the “FEC Level” that is one row down?  So for example I want a calculated field that would divide the “Sum of Customers” on level 3 which is 56 by the “FEC Level” 4…..  so 56 divided by 4.  The result 14 would show on Level 3 in line with the 56 number.

       

      FEC Level   Sum of Customers              NEW CALC FIELD WOULD BE LIKE THIS

      0                              5                                       5/1 = 5

      1                              36                                     36/2 = 18

      2                              39                                     39/3 = 13

      3                              56                                      56/4 = 16

      4                              155                                   and so on

      5                              633

      6                              785

      7                              987

      8                              1123