Question

Why can not I multiply by 1.13?

Workflow

Updated July 26, 2018

asked on July 18, 2018

Hi all,

I'm trying to get a value from a multiplication but, during my save, I have something strange.

If my function is : var*1.13 my result isn't save in my database

but if my function is : var*(1+13/100) my result is saving in my database.

The first line is for *1.13, the second one is for *(1+13/100)

Is it a bug or?

0 0

Replies

replied on July 18, 2018

The formula should work. Do you have any language settings that may be contributing to the problem? The reason I ask is that your database value seems to have a "," separator instead of a "." separator.

If that's the case, try using 1,13 instead and see if that does the trick.

0 0

View 2 previous replies

replied on July 18, 2018

Hi Jason,

Thank you for your help.

I tried to use 1,13 too but I have an error in the formula ("," = string so I can't use math).

In my database, I made a varchar(max) ; so even if the formula return "," or "." this should save into my database.

0 0

replied on July 18, 2018

Okay, just thought I would check. I tested it on my end and I didn't see any issues. I would suggest you put in a Track Token activities to see what the values are at each step in the process.

I used a token with the "Number" tag, multiplied it by 1.13 in the token calculator activity, and got the expected results.

0 0

replied on July 18, 2018

Jason I tried this steps too ^^

From the workflow I didn't have any errors, but the result didn't save into my database

0 0

replied on July 18, 2018

Can you get a screenshot of what it shows when you track the token values?

0 0

replied on July 19, 2018

My guess is it's a conversion error with value types (all too common with SQL) but I don't see how that would happen unless your token or SQL table value types were changed around in the middle of your troubleshooting. I've had to specify token types on the Workflow side to get numbers to feed into SQL tables, and I've seen it do odd things where it works one way, but not another.