Error while converting string into double and assigning it into double variable

[rifnanahas (rifna)]

I have two string values. I convert each one into double and subtract it as Convert.ToDouble(TeamTimeEntry)-Convert.ToDouble(BillHrs). and store it into a double variable Hrs using assign activity. But I am getting error as :
Assign: Input string was not in a correct format.

Please anyone provide solution to me

[Yoichi]

Hi,

Can you share specific content of TeamTimeEntry and BillHrs?

Regards,

[rifnanahas (rifna)]

TeamTimeEntry = “121.6” and BillHrs = “6.7”

[AshwinS2 (Ashwin S)]

Hi @rifnanahas

Can you remove double quotes and check the value

Thanks
Ashwin S

[Yoichi]

Hi,

It might be cultureinfo matter. Can you try the following expressions? Only one of them will work, probably.

Convert.ToDouble(TeamTimeEntry, New System.Globalization.CultureInfo("en-US"))-Convert.ToDouble(BillHrs, New System.Globalization.CultureInfo("en-US"))

Convert.ToDouble(TeamTimeEntry, New System.Globalization.CultureInfo("fr-FR"))-Convert.ToDouble(BillHrs, New System.Globalization.CultureInfo("fr-FR"))

Regards,

[rifnanahas (rifna)]

I just wrote it as an example. I use a for each row activity of data table db. Access the data as
TeamTimeEntry= data.item(0).ToString and BillHrs= data.item(1).toString.

Now need to convert into double and subtract it and assign result to a double variable

[mukeshkala]

I tried the Same Code … was able to get the Output.

One thing you can try :

Convert.ToDouble(TeamTimeEntry.ToString)-Convert.ToDouble(BillHrs.ToString)

Also , Please verify The Output variable Datatype Correctly set to Double

–
Mukesh