Formula columns can be cloned to reduce the amount of time it takes to create a template. This would be particularly useful if you wish to use an existing formula column as the framework for one or more new ones, meaning you do not have to create a brand new formula from scratch. When a formula column is cloned, it is automatically saved and can be used to clone from in future, in this template only.
NOTE: Only IF THEN ELSE and NESTED IF THEN ELSE formulae can be cloned. These formulae can be cloned only if the selected template already contains an IF THEN ELSE or a NESTED IF THEN ELSE formula.
Only formulae that already exist in the selected template can be cloned. It is not possible to clone formulae from other templates.
Select either IF THEN ELSE or NESTED IF THEN ELSE from the Formula Type drop-down list.
If the template already contains a formula column of the selected type, the Clone From check box is displayed.
Select the Clone From check box to display a drop-down list.
From the drop-down list adjacent to the Clone From check box, select the formula you wish to clone to display its details in the bottom half of the wizard.
Edit the formula criteria as required. The majority of the information from the original formula is displayed. The only items that are not displayed are the initial Column/Constantvalues in the IF statement. However, the content of all of the fields and the drop-down list can be edited, if required.
Once the required formula and criteria have been selected, click the Finish button. The new formula column is then displayed at the bottom of the Template Columns panel on the Template Details page.
Inserting an If Then Else Formula on page 154
Inserting a Nested If Then Else Formula on page 156
Adding Formula Columns for Data Review
Formula columns for Data Review are provided to display the outcome of a calculation, but not store the result.
From the Template Columnspanel of the Template Detailspage, click the Newbutton to display the Create Template Columnswizard.
Enter a Heading for the Column, up to a maximum of 25 characters. It is advisable to name the column in such a way that it indicates what type of calculation is being performed, e.g. Mean of Maths Score.
Select the required formula from the Formula Typedrop-down list noting that the formula available will depend on the type of aspect selected in which to store the result (please see Selecting and Using Formula on page 142).
Click the Finishbutton once the required formula and criteria have been selected. The formula column will then appear in the template definition column list.