You can check for the existence of K in the value. If K is present, just replace it with nothing and convert the rest of the value to number format and multiply it by 1000. If K is not present you can simply add it to other numbers but make sure to convert it to number format if it is string.
So you can, check the value that you’re retrieving from get text activity, suppose you’re getting that in strData.
I’m creating a Amount Value of Double type.
also creating a variable called sum of double type
That way you can insert a numeric value in the excel.
Also the sum could be performed in the if condition itself.