Calculation error

[#1]

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

[marcus_sommer · Accepted solution]

The syntax isn't quite correct, try this:

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

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

- Marcus

[#3]

It works! Thanks for your help Marcus.

[prma7799]

Hi Hasvine,

If you get right answer then please mark it as right answer.It is helpful to others.

Thanks

PM