Calculated fields serve as invaluable tools for various processes such as lease renewals, move-ins/outs, and invoicing, among others. They empower you to perform calculations based on the values in other fields. In Aptly, add a calculated field from Settings → Board Fields. Elevate your efficiency and precision with this feature.
In this article, you will learn:
- How to add a calculated field
- How to use a calculated field in a calculated field
Add a calculated field
Before adding a calculated field, it’s important to know what you are trying to calculate. Knowing the equation beforehand will help with the setup.
Open the board’s Settings → Board Fields, then select New Field.
- Click on + New Field.
- Select Calculated Field as the field type.
- Name the field and choose its format, rounding (when available), empty-value handling, and operation.
- Select the fields used in the calculation. Complete the required inputs before saving, then check the result against a known example.
Use a nested calculated field
You can now use the results of a calculated field within a calculated field.
For example, you want to share the proposed rent increase with your tenant who is up for renewal. However, you include their pet rent and the market rent as a part of the offer.
- Create the first calculated field - market rent + pet rent. This is titled Total Rent.
- Create a new calculated field. Total Rent x 5%. Let’s title this Proposed Rent Increase.
- Bonus: Use 2 calculated fields within a new calculated field. Total Rent + Proposed Rent Increase.