2 Replies Latest reply on Dec 13, 2017 9:32 AM by Nicolas Planchon

    How to get an average with criteria ?

    Nicolas Planchon

      Hi there,

      I have a little issue: I want to calculate an average of an amount of sales in a gap of (D-15;D+15). I have used a binary var to target my D. The D day is 1 in my var [DAY_OR_NOT] and other days are 0.

       

      Do you know how I can process to generate my average on this (D-15;D+15) gap please ?

       

      Thanks in advance,

      Nicolas.