M5 have a feature that helps user to calculate any kinds of calculation from simple addition to multiplications and more.
Firstly, create the necessary fields for the calculation. In this example, My Budget, My Expenses, and My Savings will be used in which all will be "Money" field category.
In the field that needed for the calculation (in this case My Savings), press the cog icon to get the advanced settings for the field.
In the advanced settings, in the Dynamic value section, press the "Pick Fields" to get the direct fields from the form.
From here, can pick the fields needed for the calculations. In this case My Budget and My Expenses.
In this example will be shown just the subtraction between the two fields as shown below.
After finishing, press save changes and run the application to test the calculation.
The result will be shown below.
Comments