TARGIT Calculations - overview

With the TARGIT Designer client, you can add client-based calculations to your data objects.

You do this from the 'Calculations' Smartpad in your TARGIT client:

The Calculations Smartpad offer three types of calculations:

• Pre-defined calculations. In example above, from 'Total' to 'Rank (Ascending)'. These calculations can be added to any selected object for immediate assessment. The results may vary, depending on the number of measures and dimensions in the selected object.
• Advanced calculations. This will open the objects in a calculation editor where the calculation syntax can be resolved by clicking individual columns and rows directly in the crosstab. See "Advanced" calculations - the 'point and click' editor.
• Custom calculation. When you select this option, you will need to type in the full calculation syntax yourself. Most of the articles in the Calculations section are related to the custom syntax. Below, you may read a short introduction to this syntax.

When you insert a calculation in an object, you will always need to refer to the columns/rows/cells of the data bearing crosstab. Even if it is a chart - remember that you always have a crosstab "behind" the chart.

A calculation will always need a function as well - e.g. sum, avg, count etc.

function(column reference, row reference, measure reference)

Examples:

sum(d1, 0, m1)

avg(d-1, 0:-11, m2)

allcount(0, all, 0)

Adding a Custom calculation

Custom calculations can be added in three different ways in the TARGIT client:

• Smart calculations are a set of pre-defined calculations that with a single click and in an intelligent way can be added to existing objects. The end-user does no need to know about the calculation syntax to use Smart calculations.
• Advanced calculations is a kind of calculations editor that can be useful when creating calculations that is not covered by the Smart calculations. In the Advanced calculations editor you create calculations in a point-and-click manner.
• Custom calculations require the end-user to be able to write the calculation syntax from scratch. Knowledge about the full calculations syntax is achieved by participating in the TARGIT Calculations Expert course.

Also, see the Calculations quick reference sheet (cheat sheet)