Perform calculation using variables

Help
1

Hi,

I am trying to do a calculation where:

Purchase order quantity MINUS Previously received quantity = Remaining Amount

I get an error "option strict on disallows implicit conversations from ‘String’ to ‘Double’. What does this mean?

Regards,

Jeff

Calculation%20Issue
Calculation%20Issue1359×307 27.6 KB

2

use Convert.ToInt32(yourvariable) or Convert.toDouble(yourvariable)

3

Hi,

Thanks for your incredibly prompt response. The problem we are having is that in the variable “Insufficient Amount” which is being used to perform the calculation the variable type is currently string. What should the variable type be here?

Regards,

Jeff

4

image
image804×606 14.7 KB

5

To answer your question, Int32.

You can either set it up to be straight int32, or convert it from string like @asesor-rpa has mentioned.

6

Hi again,

For your variables my data and other data what is the variable type for these? I want my result to have decimals.

Regards,

Jeff

7

If you need decimals you need to convert your string / integer to double.

Off the top of my head it would be Convert.ToDouble(yourvariable)

8

Hi,

Thanks for your response. I attempted to convert a string variable to a double and I got the attached error.

Regards,

Jeff

ConversionIssue
ConversionIssue1357×190 18.1 KB

9

you need to use an “Assign” activity:
1.
image

image
image692×125 1.33 KB

image
image937×108 1.88 KB

see: stringtodouble.xaml (5.0 KB)

10

All your variables are of type String. You cannot do subtraction on strings. Best way would be to change the type of all those variables to System.Double.

If you are particular to keep the variables as String use the expression like below. Use it in an assign activity instead of using it in Default.

CStr(CDbl(POOrderQty) - CDbl(PreviouslyReceivedQty))

2019-05-30_06-01-40

Note: The above expression could cause errors, if your String variables are not valid numbers