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

    Calculating YTD based on the dynamic year and week parameter

    Ishan Kumar

      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.