https://community.qlik.com/t5/Reporting-Service-Alerting/How-to-Convert-Minutes-in-Hours/m-p/2434601#M920 <P><span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="after" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/162719iE9584D1C009E4D81/image-size/medium?v=v2&amp;px=400" role="button" title="Screenshot 2024-03-26 094657.png" alt="after" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">after</span></span><span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="my formula to change Sum(durationminutes) to my new field: Zeit Stunde:Minuten" style="width: 440px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/162720i24BB7D7C9166399D/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot 2024-03-26 094051.png" alt="my formula to change Sum(durationminutes) to my new field: Zeit Stunde:Minuten" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">my formula to change Sum(durationminutes) to my new field: Zeit Stunde:Minuten</span></span><span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="Screenshot 2024-03-26 094051.png" style="width: 440px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/162718iE22EC5F8657250F0/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot 2024-03-26 094051.png" alt="Screenshot 2024-03-26 094051.png" /></span>as you can see it did not change like i wanted, the original field is on the right and on the left the new one. the results in my new element are my missing. Can someone tell me what i did wrong?</P> Fri, 15 Nov 2024 21:03:13 GMT Alihan_02 2024-11-15T21:03:13Z https://community.qlik.com/t5/Reporting-Service-Alerting/How-to-Convert-Minutes-in-Hours/m-p/2434601#M920 <P><span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="after" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/162719iE9584D1C009E4D81/image-size/medium?v=v2&amp;px=400" role="button" title="Screenshot 2024-03-26 094657.png" alt="after" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">after</span></span><span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="my formula to change Sum(durationminutes) to my new field: Zeit Stunde:Minuten" style="width: 440px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/162720i24BB7D7C9166399D/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot 2024-03-26 094051.png" alt="my formula to change Sum(durationminutes) to my new field: Zeit Stunde:Minuten" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">my formula to change Sum(durationminutes) to my new field: Zeit Stunde:Minuten</span></span><span class="lia-inline-image-display-wrapper lia-image-align-left" image-alt="Screenshot 2024-03-26 094051.png" style="width: 440px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/162718iE22EC5F8657250F0/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot 2024-03-26 094051.png" alt="Screenshot 2024-03-26 094051.png" /></span>as you can see it did not change like i wanted, the original field is on the right and on the left the new one. the results in my new element are my missing. Can someone tell me what i did wrong?</P> Fri, 15 Nov 2024 21:03:13 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/How-to-Convert-Minutes-in-Hours/m-p/2434601#M920 Alihan_02 2024-11-15T21:03:13Z https://community.qlik.com/t5/Reporting-Service-Alerting/How-to-Convert-Minutes-in-Hours/m-p/2434635#M922 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/293574">@Alihan_02</a>&nbsp;</P> <P>since in the table you are using ad aggregation function, Sum(durationMinutes), I suggest you also use it in the formula.</P> <P>Interval(Sum(durationMinutes)/24/60, 'hh:mm')</P> <P>Regards</P> <P>Fabiano</P> Tue, 26 Mar 2024 09:57:47 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/How-to-Convert-Minutes-in-Hours/m-p/2434635#M922 Fabiano_Martino_Intelco 2024-03-26T09:57:47Z https://community.qlik.com/t5/Reporting-Service-Alerting/How-to-Convert-Minutes-in-Hours/m-p/2435066#M931 <P>Danke&nbsp;</P> Wed, 27 Mar 2024 09:09:58 GMT https://community.qlik.com/t5/Reporting-Service-Alerting/How-to-Convert-Minutes-in-Hours/m-p/2435066#M931 Alihan_02 2024-03-27T09:09:58Z