20 Replies Latest reply: May 6, 2016 6:49 AM by vijaykrishnamraju vegesna RSS

    get the selected working days for previous year

    vijaykrishnamraju vegesna

      hi all,

       

      i had a scenario like

       

      =if(count({<SalesFy={$(=max(SalesFy)-1)}>}billnumber)>0,count({<SalesFy={$(=max(SalesFy)-1)}>billdate))

       

       

      The above query working fine financial year,month

       

      but when i select some 4 dates in current year i need to get the same month four dates for previous year

       

      this is for current year and previous year sales comparsion purpose and also for to see the working days count for current and previous year..

       

       

      Thanks in Advance