Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to divide timestamp by a number and get day, hour, and minute results. I currently have
Interval(END_DATE_TIME-WO_DATE_TIME,'hh: mm')/Sum([WO Count]) this give me a number I need it the be in DD MM HH format
If there is a END_DATE_TIME for every counted workorder, you might simplify this as
Interval( Avg(END_DATE_TIME-WO_DATE_TIME) , 'd mm hh')
-Rob