How do I use formula reference?

Formula reference enables you to refer to formulas applied to Columns, Series, and other sub-components within the same Klip (this includes multicomponent Klips). Formula references refer to formulas before actions or date properties are applied.

Note: If you want to reference a formula after actions or date properties are applied, use results references.

In the image below, the formula or data selection: @B:B, is evaluated using the lightning bolt button on the far right of the formula bar. The Evaluation Results display the dates as the formula output. However, the dates shown in the Klip preview have a different format because a date property was applied.

Formula reference always refers to the formula output or the Evaluation Result of the formula. 

Although formula references save time in creating duplicate formulas, every formula reference is recalculated which means there is no efficiency gained in executing the formula by using a formula reference. This is does not apply to results references. 

To use a formula reference: 

  1. Type ! into the formula bar.
  2. Select the sub-component with the formula you want to reference from the dropdown list.