Formatting real values in Reply tab

nvdvelden · Post by **nvdvelden** » Tue Jul 13, 2004 1:06 am

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

KS-Soft · Post by **KS-Soft** » Tue Jul 13, 2004 11:57 am

14 digits???
What test method do you use? Version of HostMonitor?

Regards
Alex

nvdvelden · Post by **nvdvelden** » Fri Jul 16, 2004 6:01 am

I use the result of a division made on the server and accessed by ACCESS

nvdvelden · Post by **nvdvelden** » Fri Jul 16, 2004 8:02 am

In addition to my previous answer: The version of HM is 4.42

Marcus · Post by **Marcus** » Fri Jul 16, 2004 9:02 am

accessed by ACCESS

So why don't you let access round the number??

KS-Soft · Post by **KS-Soft** » Fri Jul 16, 2004 12:26 pm

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

nvdvelden · Post by **nvdvelden** » Mon Jul 19, 2004 12:51 am

Yes,

That's right.

KS-Soft · Post by **KS-Soft** » Wed Jul 21, 2004 7:42 pm

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

nvdvelden · Post by **nvdvelden** » Thu Jul 22, 2004 2:10 am

I converted the output into integer. The accuracy is still enough.

Thanks