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


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


      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.