Deletes comma/ decimal seperator

Learn Academy Feedback
, , , , , , ,
1

Hi i have a variable ( generic value ) that contains a dynamic number. The number its eveyrthing from 0,00 - 100000,00 ( you get the idea) anyways. I am also performing a divider/math on that generic value to find a a number that i need to use later. This its been stored into a double. Problem is when i perform the divide it throws and error ( because it cant divide a generic value into a double ) thats fine, so i made i fix with Double.Parse(M3_PRIS.ToString, NumberStyles.Currency, cultureInfoUs) / 0.65
the problem now its that it cuts out the “comma/decimal seperator”. So example the main number its 79,10 after calculation it gives 7910. Something thats totally wrong…
How can I perform the calculation and still keep the decimal seperator

Thanks in advance

2

Hy @langsem,

to convert your generic value to number try the ‘Format Value’ Activity

image

If it works properly please like my post and mark my answer as solution, it helps me
Any questions please let me know

Regards

1 Like
3

could you draw up an example ? not sure if that can work :S
Because i need to perform Genericvalue / 0.65 then convert to double

4

Hy @langsem,
I believe you better first convert your generic value to number prior to the division, ok?

1 Like
5

hm.What i get first its the number from a dt, thats stored into a generic variable as a string. I then want to perform a divion on that string to find a value ( my calculation its variable.tostring / 0.65) that gives me the total number of that stored variable example 100.00 i then store it into another variable thats a double. But inside this process i would need to maintain the comma 100(,)00 else it gives wrong value

6

Hy @langsem,

I will work on a model and get back to you shortly

Regards

1 Like
7

Thank u so much, i am trying another solution in the meantime :slight_smile:

8

Hy @langsem,

To get the number from the data table, you can convert it to “Double” like this:
MyValue = CDbl(row(0).ToString)

Have a look at my file, almost there :slight_smile:

Regards
Convert_GenericValue_Number_Test.zip (28.9 KB)

1 Like
9

This one worked perfect m8, thanks alot !

1 Like
10

Very glad I could help @langsem, happy automation

The last thing I would ask you is to like all my posts in the thread!, :slight_smile:

Thanks

1 Like
11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.