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

Calculation error

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

• Re: Calculation error

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

• Re: Calculation error

It works! Thanks for your help Marcus.

• Re: Calculation error

Hi Hasvine,

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

Thanks

PM