Creating Calculated Columns

The fields are described as follows:

• Name: Choose a name for your calculated column.
• Data Type: Choose whether your calculation is text, number, or date.
• Format: Choose a format for number or date calculations (for example, show the date as DD-MM-YYYY).
• Number/Date/Text groups: A list of all the columns available from the tables that are included in the query. These columns are grouped into their base format. Select each header to slide open the list of columns available in that base format.

Choose and drag columns from the list and select operands and function buttons at the top to build your formula for the calculation.

Here, we have used the IF/THEN/ELSE condition to output amount * 12 if the frequency of the compensation is monthly.

Static values are input with Click this button to add a text, number, or date static value into the calculation.