Why is this simply 'x divided by Y' not calculating correctly?

Help StudioX
,
1

From a JSON file I need to perform the following calculation; Cost / Quantity = Amt per quantity

In the example where im reciving and error. The calculation is 6.6/10 = 0.66 (should equal)
UiPath is returning 6.6/10=0.6599999999999999.

What is that all about? where are the 99999s coming from?

Im using

Convert.ToDouble(Currentrow(“cost”))/Convert.ToDouble(Currentrow(“quantity”))

This image depicts a debugging session in an Integrated Development Environment (IDE), showing a workflow of sequences, variables, and assignments with a highlighted assignment operation and the resulting value in a "Locals" pane. (Captioned by AI)
This image depicts a debugging session in an Integrated Development Environment (IDE), showing a workflow of sequences, variables, and assignments with a highlighted assignment operation and the resulting value in a "Locals" pane. (Captioned by AI)1823×901 83.6 KB

2

@Waterfowl_Waterfowl_hunte,

You will have to round it off using Math.Round function. Use this code:

Math.Round(Convert.ToDouble(Currentrow("cost"))/Convert.ToDouble(Currentrow("quantity")),2)

This should give you output as 0.66

Code:

The image shows a workflow in a software automation tool where a value is assigned to the variable "dblAmt" using the Math.Round function, and then this value is logged in a "Log Message" activity. (Captioned by AI)
The image shows a workflow in a software automation tool where a value is assigned to the variable "dblAmt" using the Math.Round function, and then this value is logged in a "Log Message" activity. (Captioned by AI)901×522 18.3 KB

Output:

The image shows the output window of a development environment indicating that debugging has started for a file named Main, with two informational messages and one warning, but no errors. (Captioned by AI)
The image shows the output window of a development environment indicating that debugging has started for a file named Main, with two informational messages and one warning, but no errors. (Captioned by AI)533×284 13.7 KB

3

Im getting this now. Everything has a variable type of double. we have been playing with it but not getting anywhere. any suggitions?

A compilation error has been encountered in the Expression Editor due to the 'Math.Round' function not being recognized as a member of 'Integer'. (Captioned by AI)
A compilation error has been encountered in the Expression Editor due to the 'Math.Round' function not being recognized as a member of 'Integer'. (Captioned by AI)1263×418 31.4 KB

4

@Waterfowl_Waterfowl_hunte,
Try this one

Math.Round(CDbl(Convert.ToDouble(Currentrow("cost"))/Convert.ToDouble(Currentrow("quantity"))),2)