How do I create a calculated field?

Note: This content is applicable to the legacy web version of Timegate Web.

From within your report, when you are in the Configuration Mode:

• Select +Add Calculated Field. The following screen will be loaded:

• Enter a Column Name

• Next, enter an Expression. This can be done with the keyboard, or interactively, following prompts on the screen. The format of the expression takes that of SQL. The on screen expression builder simplifies this process and enables you to choose fields and functions/operators to address your needs. An example of an expression that calculates in years how long ago someone joined the company is: DATEDIFF(yy, [Employees].[JoinedDate],GETDATE()

• Enter a Data Type from the selection available on screen. If you are unsure what a value means, you can always search online for the various SQL terms and their related parameters.

• Select Preview to test that the field is working correctly and that you will get some results from the query

• Select OK

Once saved, your calculated field will be available to add to your report part