1 2 Previous Next 21 Replies Latest reply on Apr 11, 2018 2:29 PM by Jim Dehner

    How to calculate sum of square of each element in the group

    Uday Kintali

      Hi ,

      I have a table like this :

      CategorySubcategory type
      Value SumofSquares ( Calculated Field)
      a

      a1

      no-change10
      a2test15sqrt(10^2 + 15 ^2 + 30 ^2)
      a3test30sqrt(10^2 + 15 ^2 + 30 ^2)
      bb1no-change5
      b2test10sqrt(5^2 + 10 ^2 )

       

      I am trying to create the last column based on the other columns in the above table. So, irrespective of how many sub-categories I have for each group, I want to create  a calculated field which calculates sums of squares of each value.

       

      Could you please help me understand how to calculate this ?

      Please let me know if you need more information.

        1 2 Previous Next