Within the Executive Summary, as well as selecting from our pre-set list of tags to automatically complete the page with data from your report, you can set up your own custom tags. This can be useful to feature specific KPIs or measures, report on values from individual accounts, or display the result of any other calculation based on the data you've imported into Spotlight.
To set up a custom tag
You can set up the custom tag from within the Formula Gallery for the organisation.
From the main Spotlight screen, click the Settings link under the organisation name, then click the Formula Gallery tab.
Alternatively, if you're working in the Executive Summary, within the section you're working in click the Tags option, then hover the mouse over the Custom option, and click Create Custom Tag. You'll then be prompted to go to the Formula Gallery to set up the new tag.
Note: You can also access the Formula Gallery from the practice settings at the top right-hand corner of the main Spotlight screen. However, if you access it in this way, please note that you will not be able to create organisation level formulae using individual account names, as these are held at organisation level.
To set up a new formula from scratch, click Create New Formula.
Alternatively, if you want to amend an existing formula, you can click the Copy and Edit button (
) alongside a default formula, or click the Edit button (
) alongside a formula you've previously created.
Next, use the Formula Builder to set up the formula you need. This formula can use imported accounts or accounts you've set up manually within the non-financial section.
Once you've finished creating your formula, click Save As.
From the Available to drop-down list, choose either Organisation or Practice. If you choose Organisation, your formula will be available only within this organisation. If you choose Practice, the formula will be available to all organisations.
Enter a name for the formula.
If required, enter any formula tags. You can use these to search for the formula later.
To save the formula, click Save.
To apply a custom tag to your Executive Summary
In the Customise Layout tab, click to Customise the Executive Summary page.
Click into the section where you want to place the custom tag, then click the Tags drop-down list.
Click Custom, then select the tag you want to insert.
The name of the tag appears in the data entry box, and when you click outside of this box, the result of your formula appears. This will automatically update in future, based on the report date.