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

    Row calculation

    paolo.raia

      Hi,

       

      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.