I hope this message finds you well. I have encounter the following issue, and I would like to know which would be the most efficient way to solve it.
In one of my modules, I have a field with an amount as a currency value and a field with a percentage type. Both are multiplied in a function field to calculate a Commission revenue.
As it is a percentage field, we have entered so far all commission percentages as a whole number. For example, for 20% we have introduced 20, for 35%, 35 and so on.
My mistake was that, assuming that the field type was already a percentage, I just needed to multiply the amount by the commission percentage field. I did this and noticed that the product had been for example ($1,500, 25%): 1500
* 20 instead of the desired 1500
* 0.2.
Thus, I simply added to the function a division by 100 and I solved this. However, now I have hundreds of records with a wrong number that I wish to update. When I updated the function, I saw a message that explained that this change was not retroactive and records should be updated manually. When I enter to a record, I just click "Edit", then "Save" and the new function is applied.
It is simple, BUT, is there a way to mass update these hundreds of records?? When using the "Mass update" function, I need to update a particular chosen field with a particular value and in this case this falls out of this scope.
What are your opinions?
Thank you very much!
J.