Get value from spreadsheet column to calculate Median

 
1
0
-1

Hi experts,

I am trying to calculate median for a column in a spreadsheet. Is there any way doing this using calculation field? If no, anyone know how to get the value in spreadsheet column so I can work on Java script for median calculation.

Spreadsheet id = spreedSheetASTM

Column id = dumbellThickness

    CommentAdd your comment...

    3 answers

    1.  
      2
      1
      0

      Hi I've found the method by using Javascript API 

        CommentAdd your comment...
      1.  
        1
        0
        -1

        var values = FormUtil.getGridCellValues("spreedSheetASTM.dumbellThickness");

          CommentAdd your comment...
        1.  
          1
          0
          -1

          I also got same question... have u got solution for this?

            CommentAdd your comment...