AnsweredAssumed Answered

#MULTIVALUE error on Cross Tab table format

Question asked by vchinni on May 20, 2015
Latest reply on Jun 3, 2015 by Catherine Schuman

I noticed that in a Cross tab table report format, #Multivalue is displaying on Last Log Solution column and after researching I found that the service desk Analyst entered 2 log solutions in the same ticket within few seconds after submitting the first one. Is it possible to display only the last one by using a relevant formula rather than having to tweak the current SQL query using max() query ?

   alg.time_stamp  =  (select max(alg.time_stamp) from alg where alg.call_req_id=cr.persistent_id

Outcomes