hexagon logo

Double loop reporting

Running a double loop and trying to get the report to read right but having issues on the 2nd number in the loop counting correctly in the dimensions. Attached is the report. Its doing the correct first loop by doing the Average [1,1] [Average[1,1] [1,1] [2,1] [2,1]so on. But should be going [1,1] [1,2] [1,3] [2,1] [2,2]. Tried numerous variations and also added a count. Any solutions?

Attached Files
Parents
  • I would say, if you want to use "COUNT", that COUNT=0 should be in loop V11.
    If you write it in loop V20, then, it's zero at each begining of loop, then +1, so it's always 1. (In your screenshot, COUNT isn't used).
    You could try (in loop V20) :
    ASSIGN/VXX="AVERAGE["+V11+","+V20+"]"
    Then dimension VXX.
Reply
  • I would say, if you want to use "COUNT", that COUNT=0 should be in loop V11.
    If you write it in loop V20, then, it's zero at each begining of loop, then +1, so it's always 1. (In your screenshot, COUNT isn't used).
    You could try (in loop V20) :
    ASSIGN/VXX="AVERAGE["+V11+","+V20+"]"
    Then dimension VXX.
Children
No Data