Round function In QTP Not Working

Replies

• 

  Kaustubh Katdare

  Marking #-Link-Snipped-# & #-Link-Snipped-# . Can you guys help?
• 

  Saandeep Sreerambatla

  I think its returning the correct value only.
• 

  Saandeep Sreerambatla

  If it is 16.956 then Round(16.956,2) will give you 16.96.
• 

  ilga gracy

  English-Scared

  I think its returning the correct value only.

  no its not for 16.955. check it for 6.955. it will return the value as 6.96. but it is not returning for 16.955, 17.955, 18.955 and 19.955
• 

  Anil Jain

  Which operating system are you using?
  Also, how you are using the Round Function?
  
  I vaguely remember that on Windows 7, Round Function works with both. decimal as well as , comma and that depends on the regional setting of the system. Check your regional setting at Control panel; check a little more around that.
  
  i meant if 16.955 is not working for you probably you have comma settings
  Try with,
  A = Round(16,955, 2)
  If you have settings that accept decimal than
  A = Round (16.955, 2) should return 16.96
  
  Let me know.
  
  -CB
• 

  KenJackson

  Did you type in 16.955 and 17.955? Or are they the results of prior calculations?
  
  If a prior calculation returned 16.9547,
  then it will be correctly displayed as 16.955 when rounded to 3 places,
  but will also be correctly displayed as 16.95 when the rounding is changed to 2 places.
  
  Otherwise, I don't know qtp, but you should make sure the Round function is documented to work the way you think. I've found various counterintuitive surprises in function documentation before.
• 

  ilga gracy

  crazyboy

  Which operating system are you using?
  Also, how you are using the Round Function?
  
  I vaguely remember that on Windows 7, Round Function works with both. decimal as well as , comma and that depends on the regional setting of the system. Check your regional setting at Control panel; check a little more around that.
  
  i meant if 16.955 is not working for you probably you have comma settings
  Try with,
  A = Round(16,955, 2)
  If you have settings that accept decimal than
  A = Round (16.955, 2) should return 16.96
  
  Let me know.
  
  -CB

  I am using windows xp. it supports only decimal point. Even Though i am not getting the result only for those values 16,17,18 and 19. Check the uploaded file. It is showing proper result for 15 and 20. but not for the above mentioned values.
• 

  Anil Jain

  ilga gracy

  I am using windows xp. it supports only decimal point. Even Though i am not getting the result only for those values 16,17,18 and 19. Check the uploaded file. It is showing proper result for 15 and 20. but not for the above mentioned values.

  Very Peculiar problem 😔
  I will research more on this and update the thread.
  
  -CB