Welcome To Automation Testing

Before starting with tips of automation of SAP using QTP Let me give a small introduction of SAP and QTP.

SAP stands for System Applications and Products. It is the name of both the online financial and

Administrative software and the company that developed it. SAP is made up of individual modules that perform various organizational system tasks.



Quick Test Professional (QTP) is an automated functional Graphical User Interface (GUI) testing tool that allows the automation of user actions on a web or client based computer application.

It is primarily used for functional regression test automation. QTP uses a scripting language built on top of VBScript to specify the test procedure, and to manipulate the objects and controls of the application under test. It supports many applications through the support of add-ins.



We will be using SAP add-in with QTP to work on the SAP automation.

Friday, 3 August 2012

Round function returns wrong result/ Round to Larger

I remember working with Round function. There was a scenario where it was returning wrong value.

'Let us see the example
dblValue=30.745
dblRoundedValue=Round (dblValue,2) 'Round for two digits after decimal

***************
Output was 30.74 instead of 30.75.

***************
Reason behind this is

The Round function performs round to even, which is different from round to larger. ... If expression is exactly halfway between two possible rounded values, the function returns the possible rounded value whose rightmost digit is an even number.
This is not what i was looking for. For me the values has to be 30.75. I developed a small piece of code which works absolutely fine for rounding values to larger.

Function Generic_RoundToLarger(dblNumber, intNumDigitsAfterDecimal)
   dblRoundedValue= CDbl(FormatNumber(dblNumber, intNumDigitsAfterDecimal))
   Generic_RoundToLarger=dblRoundedValue
End Function


Now when i call this function i get the expected value. 30.745 is returned as 30.75.

Hope this helps my reader.


No comments:

Post a Comment