I'm attempting to create a query utilizing downtime. The field in question is AUSZT.
However, the breakdown duration output takes the following format: 1.5351340900000000E+08
This is causing some difficulty when it comes to presenting the data and also, the bigger issue arises when it comes to calculating this output.
Instead of 1.5351340900000000E+08, this should be 1.54
Looking for some help on how to extract this data so it looks "normal" using SQ01. Any advice?
Edited by: PMPSMM on Sep 13, 2011 3:32 PM