Hi Guys!
I need to create min/max value report. I have created a duration formula but need to gather the Min and Max for the valules. I am using these formulas for the duration formula:
DateTimeVar StartTime;
If {Reports_Events.Type} = 'start' then StartTime := {Reports_Events.Timestamp};
StartTime
If {Reports_Events.Type} = 'Stop' Then DateDiff('s',{Reports_Events.Timestamp},
{@startTime})
I have to calculate the minimum and maximum for each unit for the month of calls. I can't figure out how to get this. I tried using the Cross-Tab expert and selecting @duration and using Minimum, also maximum still not getting the right numbers.
Any help?? Thanks!