Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

calculating avg for field short time

Status
Not open for further replies.

elisnery

Technical User
Oct 22, 2003
1
PT
I'm trying to add a calculated member (measure) to give me the avg of time wait.
I added a measure with sum as aggregate formula. Add same measure again with count as aggeregate formula.
Then use a calculated measure with sum/count to get the average, but when I divide the field time by total, show a wrong value.
Calculated measure is formated with short time.
Where is the error?

Best Regards
Elis
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top