4 Replies Latest reply on Jul 22, 2019 3:50 AM by Ganesh Gore

    Question about Remedy Smart Reporting

    Kamala Iragavarapu
      Share This:

      Hello,

       

      Can someone please advise me on the below issue.

       

      I have created a Smart Report grabbing information about Parent and Child Assets. I need to compare the 'Room' assigned for the Parent and Child and return a text 'ROOMS MATCH' in a column when both room numbers are similar. Else, 'NO MATCH'.

       

      To do this, I am trying to create 'Case When Statement' by using a 'Calculated Field' as shown below. but I am getting the below time out error. Can you please suggest if this is how we can compare the text (Room is alphanumeric). If I am wrong, please let me know how can I achieve this? Appreciate your advice.