how to compare decimal values
Hi, I need to compare a xsd:decimal (response) element with a value that I read from an Excel spreadsheet. Because the value that I need to read from the Excel spreadsheet needs to be assigned to a...
Forum Discussion
I had the same problem. I solved it by using the fact that you can use script code in property expansion, like this:
Expected result:
In this example my Excel has a property "Sales price", which is 12.30
The database stores prices with 4 decimals, so the output of the XPath expression is : 12.3000
The DecimalFormatSymbols(Locale.US) is to ensure the output is with a decimal . as our default locale uses a ,
This way I do not have to create a script for every assertion.
Expected result:
${=new java.text.DecimalFormat("#.0000", new java.text.DecimalFormatSymbols(Locale.US)).format(${DataSource Excel#Sales price})}In this example my Excel has a property "Sales price", which is 12.30
The database stores prices with 4 decimals, so the output of the XPath expression is : 12.3000
The DecimalFormatSymbols(Locale.US) is to ensure the output is with a decimal . as our default locale uses a ,
This way I do not have to create a script for every assertion.