8 Replies Latest reply on Jul 13, 2018 1:08 AM by kumar bharat

    Average calculation on parameters change

    David Bentata

      Hi

       

      I need help to calculate average by 'avg' column data.

      Calculate data only if there a change in data in one or both of the columns 'date' or 'trans'.

      Tried to create calc. field with some calculations that I found online, without success.

         

      datetransavg
      02/07/20182917.33
      02/07/20182918.33
      02/07/20182923.17
      03/07/2018196.22
      03/07/2018199.00
      03/07/20183815.00
      03/07/20183814.75
      03/07/20183819.57
      03/07/20183823.75
      03/07/20183819.54
      03/07/20183819.54
      03/07/20183819.54
      05/07/20183811.00
      05/07/20183823.33
      05/07/2018158.00
      05/07/20181512.00
      AVG TOT17.4

       

      Thanks for the help,

      David.