2 Replies Latest reply on Jul 11, 2018 5:03 AM by paolo.raia

    Row calculation




      As an example, below is one record which is split by 6 country codes:-


      The grand total is correct at 31.00.  However, I need the sum at each row level to be the grand total (31.00) divided by the number of separate country codes (6), so the final result would read:-


      BO 5.16

      CH 5.16

      CO 5.16

      EC 5.16

      GT 5.16

      SV 5.16

      Grand Total 31.00


      I have tried WINDOWS_SUM and all sorts, but I cannot think of the methodology!


      Many thanks in advance.