Troubleshooting Calculations
Problem: Numeric calculations are not working as expected.
Solution: Verify that the following steps are correctly implemented and make changes as required.
- Use a Replace function to remove non-numeric characters. A decimal point (.) is allowed. For example, if a variables includes a dollar sign and a comma ($1,234), those characters must be removed as shown in the following image. If non-numeric characters remain, no calculation is performed.
- Verify that the Calculation procedure ends with a Set variable action.
- Verify that the procedures are in the correct order. If you want to add a value and then multiply that sum, the procedure that adds a value must occur before the procedure that multiplies it. You can drag and drop procedures within the list of procedures in the Project window to change their order.