summary cell of a crosstab HH:mm

[ines0411]

Hello,

i have a problem with the summary cell of a cross table.
HH:mm should be added. for example column nr.10--> 00:27+01:46+02:25=04:38 and not 00:27+01:46+02:25=03:98.

summary cell is formatted like
{IIF(EMPLOYEEWAGEACCOUNTVALUES.UNIT =="h",Truncate(EMPLOYEEWAGEACCOUNTVALUES.VALUE) + (EMPLOYEEWAGEACCOUNTVALUES.VALUE - Truncate(EMPLOYEEWAGEACCOUNTVALUES.VALUE))/10*6,EMPLOYEEWAGEACCOUNTVALUES.VALUE)}

Unbenannt.JPG (47.31 KiB) Viewed 161 times

Could someone please help me.
thank you.

[Lech Kulikowski]

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.

[ines0411]

Hello,

please find attached the report with test data.


Thank you.

[Lech Kulikowski]

Hello,

We need some time to check and fix the issue. We will let you know about the result.

Thank you.
#14435