This content has been marked as final.
Show 2 replies
-
1. Re: How to get an average with criteria ?
Matthew Theis Dec 13, 2017 7:57 AM (in response to Nicolas Planchon)1 of 1 people found this helpfulHello Nicolas Planchon I would suggest putting [Day_or_Not] as a filter. Select 1. Then pull the same pill onto the marks card as AVG. Let me know if this works
-
2. Re: How to get an average with criteria ?
Nicolas Planchon Dec 13, 2017 9:32 AM (in response to Matthew Theis)Hi Matthew Theis, thanks for your feedback!
Unfortunately this will only allow me to get an average on the D Day, but I also want to include sales of the 15 days before this D Day and 15 days after this D day.
I think it's a little bit trickier!
Nicolas.