15 Replies Latest reply: Dec 19, 2016 4:36 AM by Kavita Vishwakarma RSS

    YTD for the below expression..

    Kavita Vishwakarma

      Hi,

       

      Please help me with the logic for YTD..

      My expression is :

       

      sum(If(Val_Date >= Cal_MonthYear and Val_Date < AddMonths(Cal_MonthYear, 1), [Net Tractor Revenue (Domestic)]))

      /

      sum(If(Link_Date >= Cal_MonthYear and Link_Date < AddMonths(Cal_MonthYear, 1), [Net Tractor Revenue (Domestic)])))

       

       

      I want to show YTD with the above expression..

      For e.g If i select Sep Month then it should show from Apr to Sep..

      stalwar1gwassenaar

       

       

      Regards,

      Kavita