Fill in the calculation sheet
On the ”Calculation” tab in the design template, you can set up new calculations or copy calculations from other Excel sheets. On this tab you can create calculations based on input or output from self-service solutions and case guide tasks.
Select and define cells for input and output
Cells on the "Calculation" tab can be used as input fields in self-services and input or output fields in case guide tasks defined via the "Task layouts" tab. To apply a cell, you must use the cell reference (for example C5) or name the cell.
Name a cell by selecting it and specifying a unique name in the "Name" Excel field in the top left corner below the ribbon. Click Enter to name the cell.
| The cell name must be unique and may only consist of letters, integers, and underscores ("_"). It cannot contain spaces, æ, ø, å, or other special characters. |
Remember to reference the correct cell, either by cell reference or name, in the "Excel input/output" column on the "Task layouts" tab or the "Excel input" column on the "Self-service" tab.
If you are referring to an output field, remember to add its formula.
Add formula to output field
Select a cell on the "Calculation" tab to be used as an output field. Write an equals sign "=" in the cell and specify the cell reference or cell names that the output field should perform a calculation on, as well as a calculation operator.
For example, if the output field should calculate the sum of the input fields "loc1" and "loc2", write the following in the output field: =loc1+loc2 and press Enter.