1 Reply Latest reply: Mar 6, 2018 9:20 AM by Sunny Talwar RSS

    Max value from a column

    William Fu

        How can I calculate the desired Max(Step) column in the script?

       

      IDStepMax(Step)
      51962311
      52031712
      52031722
      52185311
      52327313
      52327323
      52327333

       

      I tried with FieldValue, but this gives me the overall max instead of the max by ID:

       

      Left Join ([table])

      LOAD Max(FieldValue('Step', recno()))) as MaxStep

      Resident [table];