View previous topic :: View next topic |
Author |
Message |
nvdvelden
Joined: 10 Mar 2004 Posts: 6
|
Posted: Tue Jul 13, 2004 1:06 am Post subject: Formatting real values in Reply tab |
|
|
Hi,
I am using calculations to determine wether a test is ok or not. The outputvalue is a real. How can i format this value. I now have a 14 digit output. I would like to decrease this to about 2.
Regards
Nico |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12795 Location: USA
|
Posted: Tue Jul 13, 2004 11:57 am Post subject: |
|
|
14 digits???
What test method do you use? Version of HostMonitor?
Regards
Alex |
|
Back to top |
|
|
nvdvelden
Joined: 10 Mar 2004 Posts: 6
|
Posted: Fri Jul 16, 2004 6:01 am Post subject: |
|
|
I use the result of a division made on the server and accessed by ACCESS |
|
Back to top |
|
|
nvdvelden
Joined: 10 Mar 2004 Posts: 6
|
Posted: Fri Jul 16, 2004 8:02 am Post subject: |
|
|
In addition to my previous answer: The version of HM is 4.42 |
|
Back to top |
|
|
Marcus
Joined: 18 Nov 2002 Posts: 367
|
Posted: Fri Jul 16, 2004 9:02 am Post subject: |
|
|
Quote: | accessed by ACCESS |
So why don't you let access round the number?? |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12795 Location: USA
|
Posted: Fri Jul 16, 2004 12:26 pm Post subject: |
|
|
Still don't get whole picture...
>What test method do you use?
Now I can assume you are using ODBC test method to get some field from some database. Am I right?
Regards
Alex |
|
Back to top |
|
|
nvdvelden
Joined: 10 Mar 2004 Posts: 6
|
Posted: Mon Jul 19, 2004 12:51 am Post subject: |
|
|
Yes,
That's right. |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12795 Location: USA
|
Posted: Wed Jul 21, 2004 7:42 pm Post subject: |
|
|
I think you can modify your SQL query a little (use CAST function).
E.g. if you are using query like SELECT field1 FROM table1, change it to SELECT CAST(field1 AS MONEY) FROM table1
Regards
Alex |
|
Back to top |
|
|
nvdvelden
Joined: 10 Mar 2004 Posts: 6
|
Posted: Thu Jul 22, 2004 2:10 am Post subject: |
|
|
I converted the output into integer. The accuracy is still enough.
Thanks |
|
Back to top |
|
|
|