Hello all,
I have a column for Qty in my import file and the goal is that value to be imported should by Qty/3.
I entered the same forumla in Import routine but it triggered the following error:
Cannot perform the '/' operation on System.String and System.Int32.
How to resolve this?
Best answer by lauraj46
Hi
Try converting the input field to a numeric data type:
=CDbl([SKU])/3
Hope this helps!
Laura
+16
Hey
where SKU column has my qty for each line.
+9Hi
Try converting the input field to a numeric data type:
=CDbl([SKU])/3
Hope this helps!
Laura
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
