1 Reply Latest reply: May 28, 2014 6:36 AM by Marcus Sommer RSS

    Text Object with calculated action

      Hi Again

       

      Would someone be able to help me on the following query please?

      I have the following text objects which does a count of the Oldest case on the system on the field logdate:


      =num($(vTODAYS_DATE)-(MinString({$<status_name ={'Unaccepted','Unassigned','Pending','Off Hold','On Hold'} >} [logdate])), '#,##0')

       

      What I want to do is create another Text Object under that with an action that takes me to SH02 and finds the case on a Straight Chart that only pulls through the case with the oldest case.

       

      Regards,

       

      Jon Ditchfield