Cross-tab summary
Posted: Wed Mar 12, 2014 3:12 pm
Hello.
I'm using simple cross-tab report.
| Date1 | Date2 | Total
-------------------------------------------------
Employee1 | val | val | avg?
-------------------------------------------------
Employee2 | val | val | avg?
-------------------------------------------------
Total |avg?|avg?| avg?
Where val - is amount of second.
How can I convert val to time format (hh:mm:ss) and summarize this value in totals ?
I'm using simple cross-tab report.
| Date1 | Date2 | Total
-------------------------------------------------
Employee1 | val | val | avg?
-------------------------------------------------
Employee2 | val | val | avg?
-------------------------------------------------
Total |avg?|avg?| avg?
Where val - is amount of second.
How can I convert val to time format (hh:mm:ss) and summarize this value in totals ?