Columns Formulas are a quick and powerful way to gain more insight into your data. You can add Column Formulas to Report, Tracking and Comparison Cards. In this guide we're going to cover:
- Adding Column Formulas to tables
- Inverting variance on Comparison Cards
Adding Column Formulas
You can add Column Formulas to easily explore metrics such as variances, averages, financial year summaries and report totals.
Select the 'Columns' tab on a Card and then add and remove different options to explore how they liven up your report.
Different Column Formulas will be added to different places in a table.
Summary columns are displayed only once at the end of a report.
Range columns will repeat over specified ranges, depending on how long your data range is. The financial year total will appear once at the end of every financial year in your table.
Inverting Variance on Comparison Cards
Comparison Cards allow you to compare two columns of data - this could be two Forecasts, Forecast vs actuals, year vs year.
When you're using Column Variance Formulas on Comparison Cards the default behaviour is to compare column 1 to column 2. If you need to invert this; because for example, your columns are budget vs actual rather than actual vs budget, there's a switch to invert the comparison.
Once you've selected one of the comparison column formulas, check the second checkbox to invert the comparison: