When creating calculations on a chart, in some situations, you may want to reference a value of a previous record in the chart, or reference a column in a table chart with a predefined expression. We can use an inter-record function to help us with this requirement.

These are the inter-record functions we will learn:

• Above()
• Column()

Before starting the examples, we will create a new sheet with the name Inter-Record. The following steps will help us to create and use a new sheet:

1. Open the app and click on Create new sheet
2. Set the title of the sheet to Inter-Record
3. Click on the sheet icon to save the title, and then open the sheet to start creating