3 Replies Latest reply: Mar 25, 2015 2:47 AM by P M RSS

    Calculation error

    Hasvine Dhurmea

      Hello Everyone,

       

      I was using the expression below to calculate a weightage:

       

      =(SUM({<Date={"$(='>=' & weekstart(date(today()-28)))"}>}[Nombre d'appels reçus])/SUM(TOTAL{<Date={"$(='>=' & weekstart(date(today()-28)))"}>}[Nombre d'appels reçus]))

       

       

      So what i need basically is to have the sum of all calls receive [Nombre d'appels reçus] for the last 28 days divide by the total of all calls receive in the last 28 days.

       

      It worked for the first week and for this week its taking the sum of all call received for the last 28 days and dividing it by the total of all calls received since January.

       

      Thanks in advance for your help.

       

      Kind Regards,

       

      Hasvine