Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
)
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 ))