3 Replies Latest reply: Aug 21, 2017 8:19 AM by Ahmed El Midaoui RSS

    hard calculation in range of weeks

    Ahmed El Midaoui

      Hi community,

       

      I need a help on a calculation, and after many tries, I still can't find the solution of my problem, here is the situation:

       

      My field is already created, it is called Week and contains as values : 2017W01, 2017W02 ..to.. 2017W28

       

      what i want to do is :

       

      Calculate, for each week 'x' in my field the following amount :

       

               1 -  [   (sum of the 'MP1' for the weeks : "x-4" to "x")     /     (sum of the 'WOL' for the weeks :"x-4" to "x")   ]