3 Replies Latest reply on Sep 6, 2016 3:15 AM by praveen p

    Find value of a field that is based on the Max & Min of another, at a specific level of detail

    siyang.teo

      Hi, I'm struggling to find a calculation, using the example below.

      Capture.JPG

      Need to obtain, for each Route, the starting and ending Speed defined by the max and min of the field Seq. No. This is presented in a table.

       

      I figured some LOD exp needs to be used but could get no further than below:

      {FIXED [Route]: MAX([Seq No.])}

      {FIXED [Route]: MIN([Seq No.])}

       

      Can anyone help? Sample twbx attached.