Formula references let you refer to a Klip component, such as a column, in a formula, in the same Klip. This feature is useful if you want to use the results of a formula in one component in another component's formula. For instance, you can use the SUM function in one component to summarize revenue over the past 12 months and then use that formula to compare performance to the previous year in a second component. By using formula references, you can insert that component into the formula without having to recreate it or copy and paste it into the same Klip.
Note: Every reference is recalculated which means there is no formula efficiency gained by using reference.
To use a reference value
- Type ! into the formula bar.
- Select the component from the dropdown list (see image below).
Hover over the image below to watch a short video.