summary cell of a crosstab HH:mm
Posted: Tue May 07, 2024 11:46 am
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.
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.