Convert string into Double or Integer

Convert.ToDouble(Time)*Convert.ToDouble(strOutPrice)

I’m trying to assign variable Total = Time (e.g. 11.234453 )x srtOutPrice ( e.g. 30)

I’m getting a conversion error

Hi @Giovany,

Use this code
Total =Convert.ToDouble(Time)*Convert.ToDouble(strOutPrice)

you can’t multiply with string

Regards,
Arivu

2 Likes

Hi @Giovany,

You can also store the Time and srtOutPrice variables as GenericValue types. These convert to proper number types when multiplication is performed.

Try making the variables of type GenericValue and then you can perform the multiplication without casting.


still having trouble with the annotation
both variable are genericValues

Hi @pvilleroy,

@Giovany,

If you are using Generic value if it will through the error when the value is null or empty.
So better to Convert it.

Regards,
Arivu

1 Like

Hi @Giovany,

If you are using Generic Value no need to convert to Double. if suppose Empty value it will through the error.make sure the value should not be empty or null.

if its an non empty field you use Generic Value.

Always better to use specific data type to avoid complexity

Regards,
Arivu

@Giovany I agree with what @arivu96 says but if you know your variable will not be null, you can continue with GenericValue. Just make Total also a GenericValue in your screen above and there’s no need to convert. (sorry I can’t upload a .xaml until my profile has more points)

1 Like

I get the message somehow that I cannot multiply a string with a double

Hi @pvilleroy,

@Giovany
Always better to use specific data type to avoid complexity

because may be empty/null value also it will come based on the scenario.

Regards,
Arivu

Then in your case you will need to convert and use proper data types.

Hi, @arivu96
I have Datatable with Column Type Double
Now using get row item i am populating that column but sometimes the column value will be empty so it throws an error that can cast null to double.
Please suggest best possible way

DT1.Compute(“sum([#Amount])”,“Agent='” & row(0).ToString & “'”)

I am working on this and unable to resolve the error as it is giving "Invalid usage of aggregate function sum() and type: object.

It is working when i using a build in datatable in studio but not when i am reading the data from excel.

Please suggest

Thanks