4 Replies Latest reply: Aug 15, 2014 5:36 AM by Jonathan Ditchfield RSS

    Finding the Max Value in Text Object

      Hi,

       

      I have a specific query where I need to find the information from my field updatetxt depending on the value of another field udindex.  I created a text object and on my expression wrote the following:

       

      if(max(udindex),updatetxt)

       

      However the text field is blank.  I suspect this is because my udindex can be anywhere from 1 to 113 and therefore when I click on the specific record that has a primary key of callref, it cannot see which text field I need.

       

      Is there a way that I can add in my expression to get the data from updatetxt depending on the MAX value?

       

      Regards,

       

      Jon Ditchfield