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)