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)}
Could someone please help me.
thank you.
summary cell of a crosstab HH:mm
-
- Posts: 6360
- Joined: Tue Mar 20, 2018 5:34 am
Re: summary cell of a crosstab HH:mm
Hello,
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
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
Hello,
please find attached the report with test data.
Thank you.
please find attached the report with test data.
Thank you.
-
- Posts: 6360
- Joined: Tue Mar 20, 2018 5:34 am
Re: summary cell of a crosstab HH:mm
Hello,
We need some time to check and fix the issue. We will let you know about the result.
Thank you.
#14435
We need some time to check and fix the issue. We will let you know about the result.
Thank you.
#14435