Page 1 of 1

summary cell of a crosstab HH:mm

Posted: Tue May 07, 2024 11:46 am
by 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
Unbenannt.JPG (47.31 KiB) Viewed 18081 times

Could someone please help me.
thank you.

Re: summary cell of a crosstab HH:mm

Posted: Tue May 07, 2024 1:43 pm
by Lech Kulikowski
Hello,

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

Thank you.

Re: summary cell of a crosstab HH:mm

Posted: Mon May 13, 2024 7:20 am
by ines0411
Hello,

please find attached the report with test data.


Thank you.

Re: summary cell of a crosstab HH:mm

Posted: Mon May 13, 2024 8:54 am
by Lech Kulikowski
Hello,

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

Thank you.
#14435

Re: summary cell of a crosstab HH:mm

Posted: Mon May 27, 2024 7:38 am
by ines0411
Hello,

I am reaching out regarding ticket #14435.
Have you had the chance to make any progress on this case?
Any updates you could share would be greatly appreciated.

I thank you.

Best regards

Re: summary cell of a crosstab HH:mm

Posted: Tue May 28, 2024 8:01 am
by Lech Kulikowski
Hello,

Please send us your request on support@stimulsoft.com.

Thank you.