This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
- The Append Fields generates all combinations - make sure to allow all appends
- We then use a Formula to generate the new Amount:
We have to remove the % sign in the end, therefore I use Left and the Length of the string -1 to get every character except the last one. We need to use "ToNumber" to convert it to a number and use it for the multiplication. Off course we need to divide it by 100, because we want our % back.
- In the end I remove the Weight column with the Select Tool.
Workflow attached. Let me know if this solved your problem.