6 Replies Latest reply on Jun 19, 2018 5:29 AM by Zhouyi Zhang

    Need help in date condition

    sunil sudendran

      Hi team

       

      please help me creating a condition using this formula

       

      value of a day selected - moving average of values for previous week for the day selected (excluding weekends) /moving average of values for previous week excluding weekends).

       

      If i select a date as June 10 2017, then it should be like
      value for may 10 2017 -  average of values of May1 to may 5,2017/ average of values of May1 to may 5,2017


      Note :  the - indicates the difference

       

       

      Regards
      Sunil