12 Replies Latest reply: Mar 14, 2016 7:25 AM by sandip satbhai RSS

    expression going wrong in kpi

    naveen kumar

      Hello all ,

      i am trying to show current score in guage chart

       

      expression :=If(SubStringCount(Concat(DISTINCT LOCATION, ', '), 'CHANDERIA') = 1,FirstSortedValue(OVERALL_SCR,-ADATE), 0)

       

      and in presentation tab

      under

      text in chart:

      =If(SubStringCount(Concat(DISTINCT LOCATION, ', '), 'CHANDERIA') = 1,FirstSortedValue(OVERALL_SCR,-ADATE), 0)



      both the expression giving me the wrong answer


      i am getting 41 as current score(wrong answer)

      it has to be 71 (correct)


      wat going wrong please help me