Page 1 of 1

{SumTime()} function how to use it?

Posted: Tue Dec 05, 2023 7:54 pm
by alex_negotel
Good afternoon;
I have doubts about how to use this function, even though the column informs the result and it is always 0.
Can anybody help me ?
Thank you very much in advance......

Re: {SumTime()} function how to use it?

Posted: Tue Dec 05, 2023 9:31 pm
by Lech Kulikowski
Hello,

A function returns the sum of all the values in the specified column or expression.
Parameters
expression - An expression on what to perform the aggregation.
Return Value
A TimeSpan value.

Thank you.

Re: {SumTime()} function how to use it?

Posted: Wed Dec 06, 2023 11:14 am
by alex_negotel
Good morning;

Thank you in advance for your response, but I've already been using it as per the image posted, but even so the value continues to be zero.
I am using sql oracle the data type and a string converted to TIMESTAMP.
Do you know what I can adjust?

Thanks
Captura de tela 2023-12-06 103934.png
Captura de tela 2023-12-06 103934.png (13.73 KiB) Viewed 3900 times
REL_TEMPOS_PREPARACAO_FARM_ONCO.mrt
(347.62 KiB) Downloaded 311 times

Re: {SumTime()} function how to use it?

Posted: Wed Dec 06, 2023 2:40 pm
by Lech Kulikowski
Hello,

What product and version are you use?

Thank you.

Re: {SumTime()} function how to use it?

Posted: Wed Dec 06, 2023 3:11 pm
by alex_negotel
My version 2019.2.2 report designer, the same and incorporated into my ERP.
Thanks

Re: {SumTime()} function how to use it?

Posted: Thu Dec 07, 2023 7:51 am
by Lech Kulikowski
Hello,

Please send your request to the developers of your ERP. We do not know how they use our components in it.

Thank you.