shaneh Posted March 27, 2004 Share Posted March 27, 2004 I'm building a fault management system in FM7. I'm using Timestamp to record start times and end times for the fault and then calculating elapsed time. Resolution Time = Timestamp Closed - Timestamp Open The problem is, I want to create a report showing Average, Min & Max resolution times. But average(Resolution Time) doesn't work because Resolution Time is in Timestamp format, so I scripted a copy & paste from Resolution Time into Resolution Time Plain (Number format) and tried this: average(Resolution Time Plain) still no go. I've tried placing the average(Resolution Time Stamp) into a Grand Summary, Footer and Summary parts - no change. I'm sure this must be easy, but it's got me stumped. thanks shane Version: v7.x Platform: Mac OS X Jaguar Link to comment Share on other sites More sharing options...
Newbies Nasty Posted March 27, 2004 Newbies Share Posted March 27, 2004 Have you tried to make your resolution time a "time" field and have an insert calculated result script for the field? Then you could summerize the Time field. Link to comment Share on other sites More sharing options...
shaneh Posted April 3, 2004 Author Share Posted April 3, 2004 Changing the field type to Summary instead of Calculation helps a lot. :-) Shane Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7327 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now