How to get sum correct?

[#1]

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)

     )

[swuehl]

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 ))