How to get sum correct?

Mon, 11 Jan 2016 10:03:49 GMT

Hi,

I have a problem that I don't know how to handle.

I would like to view the sum of calculation per working day in a label.

I summarize the target of phone calls divided by remaining working days per user.

The problem is that when I choose multiple users, the target and working days are summarized and then the division take Place.

I need to do the calculation per user and then sum the calculations.

Anyone have an idea?

Tnx in advance

SUM(

SUM({$<Year={$(vYearNow)},Month={$(vMonthNow)}>}[TargetPhoneCalls])

/(SUM({$<Year={$(vYearNow)},Month={$(vMonthNow)},WorkingDay={1},PassedWorkingDay={0}>} WorkingDay)+1)

)

Re: How to get sum correct?

swuehl — Mon, 11 Jan 2016 12:30:20 GMT

Maybe you need advanced aggregation for this:

SUM(

AGGR(

SUM({$<Year={$(vYearNow)},Month={$(vMonthNow)}>}[TargetPhoneCalls])

/(SUM({$<Year={$(vYearNow)},Month={$(vMonthNow)},WorkingDay={1},PassedWorkingDay={0}>} WorkingDay)+1)

,YourUserField ))