Formular sum

[rolandg1881]

Hi!

I have a question:

I will try to explain the problem with my  bad english. 😉

You can see a Pivot table with the Dimensions: Abteilung(Department), Art (Projekt Descrption), Mitarbeiter (Employee), and Datum (Date).

There is a column "Kapa" this is the daily cpacity of hours for the employee = 7.7 hours

The summary in the screenshot for Kapa is 315,7 hours but this is wrong because the employee GRUMET works at one day, for exampe 08.01.2020 at four Project so this formular counts for every Project and day (08.01.2020) 4x7.7 hours!

my formular for Kapa is the following:

sum(aggr(sum(DISTINCT ZBU_Soll_Zeit_Normalbuchung),LME_Abteilung,LME_Art,Proj_EMP_such,ZBU_BeginnBuchungsdatum))

ZBU_Soll_Zeit_Normalbuchung = Daytime 7.7, LME_Abteilung = Department, LME_Art =  Art (Projekt Descrption), Proj_EMP_such = Employee and ZBU_BeginnBuchungsdatum = Datum (Date)

In the column "Kapa Test" the formular is only sum(ZBU_Soll_Zeit_Normalbuchung) there is the correct summary  

unfortunately there is a Problem with the 15.4 Values....

Du you have an idea what can i do?

Thank you very much!

Greetings Roland