Performing basic arithmetic calculations
We need to add actions to enable the bot to calculate Monthly Payment. We know the formula is (Amount + Interest)/ (Years x 12).
We have all the values needed to perform this calculation already assigned to variables. For your bot to calculate this, perform the following steps:
- Drag the Number: Assign action just below line 13, ensuring it is within the Loop action on line 7.
- Set the following properties for the Number: Assign action on line 14:
Select the source string variable/value:
($numAmount$ + $numInterest$)/(12 * $numYears$)Select the destination number variable: numMonthly - Number
The action properties dialog should look like this:
Figure 5.21 – Applying a calculation
- Click on Save.
We are near the end now; you're doing really well! The next step is to write the results to the output CSV file we created earlier.