16 Replies Latest reply: Aug 26, 2016 12:56 AM by Ishan Bansal RSS

    Calculating YTD based on the dynamic year and week parameter

    Ishan Bansal

      Hi All,


      I want to calculate ytd value for the client registered. i have filters on week and year.

      my expression is

      IF (Aggr(Sum({ 1 <WEEK={"<=$(=Max(WEEK))"}>}COUNT_CLIENT),[CLIENT]) = 1, '1 Transaction')


      the above expression is working fine for week. but i need to add year condition as well. how shall i do that?


      what if the user select only week and not year so default it should take max year available in the filter.