in reply to Re: Trying to manipulate data
in thread Trying to manipulate data

My answer looks like this now

  • B937 5 5 5 5 5 5 5 5

    B631 5 5 5 3 4 5 5 5

  • can I add an extra field to the right that will add the answers and get the average like for my second value will be like this , 5+5+5+3+4+5+5+5/8 Also can I add extra row at the end to get the total of the column value and divide by the number of the values like 5+5/2

    Replies are listed 'Best First'.
    Re^3: Trying to manipulate data
    by 1nickt (Canon) on Jan 13, 2016 at 19:02 UTC

      I should think you can do both of these things. Give it a try!

      ( You probably want to declare a counter outside the loop for the grand total, and another counter within the loop to sum the fields and make a row total, which you would print out and also add to the grand total counter ...)

      The way forward always starts with a minimal test.