6 Replies Latest reply: Jan 8, 2016 1:55 AM by jagan mohan rao appala RSS

    how to create this YTD expression ?

    Jim Chan

      Hi there,

       

      This is my hit rate % expression

       

      (Sum({<AUTO_FLG = {S}, MY_RESULT={1}>} COUNT)) /(Sum({<AUTO_FLG = {S}, SG_RESULT={1}>} COUNT))

       

      And my client want to have a YTD of the Hit Rate %.

       

      I have a YTD expression that worked on another expression and i thought of using back this expression and make some changes.

       

      Sum({<AUTO_FLG = {S},MY_RESULT = {1},KI_DATE={'>=$(=YearStart(Max(KI_DATE))) <=$(=Max(KI_DATE))'}>} COUNT)

       

      Rgds

       

      Jim