Hi,

Right now, I created a define to change a couple of time fields to the right format, then I've created a computed field that shows the difference between these two times (start and end time). I was wondering if it is possible to show the average time difference as well as the maximum time difference, by each of my BY fields? Thank you.

My code is as follows:


DEFINE FILE FACT_OR
Start_time/HHIA =HINPUT(12,'00000000' | FACT_OR.FACT_OR.START_TIME,8,'HHI') ;
End_time/HHIA =HINPUT(12,'00000000' | FACT_OR.FACT_OR.CLOSE_TIME,8,'HHI') ;
END

TABLE FILE FACT_OR
SUM
COMPUTE Length/D12.2 = HDIFF(FACT_OR.FACT_OR.End_time, FACT_OR.FACT_OR.Start_time, 'MINUTE', 'D9');
FACT_OR.FACT_OR.Start_time
FACT_OR.FACT_OR.End_time
CNT.FACT_OR.FACT_OR.CASE_NUMBER AS 'Volume'
BY LOWEST FACT_OR.FACT_OR.SERVICE

This message has been edited. Last edited by: hfung1,

You can put the computed field in your define also, and then use the sum ave.defined field to show the average per your by-fields.

Hi,

If you put your calculation in a COMPUTE, be aware that WF will SUM the Start_time and the End_time and after will calculate the difference. I doubt this is the answer you will want.

So, as GamP rightly suggests, put the calculation in the DEFINE.

Thank you it works!