Calculation fields in analyses
Using a calculation field you can quickly apply an operation, such as converting a date field to the month number or the combination of month number and month name.
Description
The following calculation functions are available:
Function |
Input |
Output |
Date+time --> Date |
Date/time field |
Date |
Date --> Week number |
Date |
Number of the week the date is in. |
Date --> Month number |
Date |
Number of the month the date is in. |
Date --> Year |
Date |
Year the date is in. |
Date --> Day of the week no |
Date |
Day (number) the date is on (Monday = 1, Tuesday = 2, etc.). |
Date --> Day of the week name |
Date |
Day (name) the date is on. |
Date --> Day of the week name (short) |
Date |
Day (abbreviation) the date is on (Mon, Tue, Wed, etc.). |
Date --> Month name |
Date |
Month (name) the date is in. |
Date --> Month name (short) |
Date |
Month (abbreviation) the date is in. |
Date --> Month no + name |
Date |
Month (number) + month (name) the date is in. |
Date --> Month no + name (short) |
Date |
Month (number) + month (abbreviation ) the date is in (01 Jan, 02 Feb). |
Date --> Year/Weekno |
Date |
Year/week (number) |
Date --> Year/Month |
Date |
Year/month (number) |
Date --> Quarter |
Date |
Year/quarter (number) |
Round to integer |
Number or amount with decimals |
Logically round to integer. |
Absolute value |
Number or amount with decimals |
Absolute value (negative values become positive). |
Time duration fields are shown as hours:minutes or hours,hundredths, depending on your settings.
Procedure
- Add calculation fields to analyses
You add a calculation field based on a Profit field. This creates a new column in the worksheet which you can name yourself.