Hello, how are you?. I have the following workflow:
1° A virtual column, called “Comission amount”.
It has a formula that multiply a [price] type column, by a [percent] type column.
This works. When i click the Test button in the editor, it returns the correct value.
2° I have an action that is triggered when some conditions are met. It saves the value of the column “Comission amount” to a non virtual column, so i can use it later without worrying about it changing again.
I was looking into the table and realized that the action wasn’t running. I tried to manually run it but got a warning that says:
Action Failed
Commission amount: this value is not valid.
So i started checking everything, and this manual action only works when i replace the percent value to a decimal value with a dot, instead of a comma (I hardcoded a number like 0.7 and it works).
But when i try to convert the [percent] column to a decimal it just doesn’t work, something like this: [price]decimal([percent]). Also tried [price](1.0*[percent]), [price]*([percent]/100). Also tried the substitute function to replace “,” with “.”
Nothing seems to work, it only works when i hardcode a decimal instead the [percent] on the editor.
What could be happening here? I hope you can help me.
Regards,
Federico.