Working with custom functions

Excel > CCH® Tagetik > Data Entry > open form

Insert a custom function

1. Select the desired cell and click to the left of the Excel formula bar or on the toolbar.
2. In the Insert function window, select Tagetik function as the category. All of CCH Tagetik’s custom functions will appear in the selection area.
3. Select the desired function and click OK.
4. In the Function arguments window, insert the values of the desired dimensions for each of the function’s arguments.
5. Click OK.
6. To recalculate the cell values according to the defined custom function, click in the toolbar in the CCH Tagetik tab.

Save a value using the TGKSEND function

To save a value that has been inserted using the TGKSEND function, save the form opened in data entry mode, or click .

Define the calculation set for TGKCALCSET

This procedure shows you how to define a calculation set.

1. In the work desktop, select the desired cells.

Note: it is advisable to select adjacent cells on which the same dimensions and/or hierarchies are defined, so that only one filter changes when they are moved horizontally or vertically. 2. Add the TGKCALCSET function (see Insert a custom function).