https://community.qlik.com/t5/QlikView/Formular-sum/m-p/1699014#M451102 <P>Hi!</P><P>I have a question:</P><P>I will try to explain the problem with my&nbsp; bad english. <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P><P>You can see a Pivot table with the Dimensions: Abteilung(Department), Art (Projekt Descrption), Mitarbeiter (Employee), and Datum (Date).</P><P>There is a column "Kapa" this is the daily cpacity of hours for the employee = 7.7 hours</P><P>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!</P><P>my formular for Kapa is the following:</P><P><STRONG>sum(aggr(sum(DISTINCT ZBU_Soll_Zeit_Normalbuchung),LME_Abteilung,LME_Art,Proj_EMP_such,ZBU_BeginnBuchungsdatum))</STRONG></P><P>ZBU_Soll_Zeit_Normalbuchung = Daytime 7.7, LME_Abteilung = Department, LME_Art =&nbsp;&nbsp;Art (Projekt Descrption), Proj_EMP_such = Employee and ZBU_BeginnBuchungsdatum = Datum (Date)</P><P>In the column "Kapa Test" the formular is only <STRONG>sum(ZBU_Soll_Zeit_Normalbuchung)&nbsp;</STRONG>there is the correct summary&nbsp;&nbsp;</P><P>unfortunately there is a Problem with the 15.4 Values....</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="rolandg1881_1-1588667445332.png" style="width: 566px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/32950i11879C19AA6F71EC/image-dimensions/566x541?v=v2" width="566" height="541" role="button" title="rolandg1881_1-1588667445332.png" alt="rolandg1881_1-1588667445332.png" /></span></P><P>Du you have an idea what can i do?</P><P>Thank you very much!</P><P>Greetings Roland</P><P>&nbsp;</P> Sat, 16 Nov 2024 18:41:50 GMT rolandg1881 2024-11-16T18:41:50Z https://community.qlik.com/t5/QlikView/Formular-sum/m-p/1699014#M451102 <P>Hi!</P><P>I have a question:</P><P>I will try to explain the problem with my&nbsp; bad english. <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P><P>You can see a Pivot table with the Dimensions: Abteilung(Department), Art (Projekt Descrption), Mitarbeiter (Employee), and Datum (Date).</P><P>There is a column "Kapa" this is the daily cpacity of hours for the employee = 7.7 hours</P><P>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!</P><P>my formular for Kapa is the following:</P><P><STRONG>sum(aggr(sum(DISTINCT ZBU_Soll_Zeit_Normalbuchung),LME_Abteilung,LME_Art,Proj_EMP_such,ZBU_BeginnBuchungsdatum))</STRONG></P><P>ZBU_Soll_Zeit_Normalbuchung = Daytime 7.7, LME_Abteilung = Department, LME_Art =&nbsp;&nbsp;Art (Projekt Descrption), Proj_EMP_such = Employee and ZBU_BeginnBuchungsdatum = Datum (Date)</P><P>In the column "Kapa Test" the formular is only <STRONG>sum(ZBU_Soll_Zeit_Normalbuchung)&nbsp;</STRONG>there is the correct summary&nbsp;&nbsp;</P><P>unfortunately there is a Problem with the 15.4 Values....</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="rolandg1881_1-1588667445332.png" style="width: 566px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/32950i11879C19AA6F71EC/image-dimensions/566x541?v=v2" width="566" height="541" role="button" title="rolandg1881_1-1588667445332.png" alt="rolandg1881_1-1588667445332.png" /></span></P><P>Du you have an idea what can i do?</P><P>Thank you very much!</P><P>Greetings Roland</P><P>&nbsp;</P> Sat, 16 Nov 2024 18:41:50 GMT https://community.qlik.com/t5/QlikView/Formular-sum/m-p/1699014#M451102 rolandg1881 2024-11-16T18:41:50Z