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

# Need help in date condition

Hi team

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

• ###### 1. Re: Need help in date condition

Hi, Sunil

Can you explain the bold part as they are the same, is there anything wrong typing?

value for may 10 2017 -  average of values of May1 to may 5,2017/ average of values of May1 to may 5,2017

ZZ

• ###### 2. Re: Need help in date condition

Hello, yes it is the same

regards
sunil

• ###### 3. Re: Need help in date condition

Then what's the point of have this formula? you just need the value of May 10 2017 in your sample, am I missing something?

ZZ

• ###### 4. Re: Need help in date condition

I need to calculate the deviation which is happening ..
so i need to create a condition using that formula