### Symptom

Currently if a calculated column is created with the formula DateX minus DateY and the result divided by a number the below error is thrown:

Text formula cannot contain any operators or condition operators

### Reproducing the Issue

- Login to the instance
- Analytics - Analytics - Detailed Reporting or Advanced Reporting
- Create a new query or edit an existing one
- Create calculated column with the difference in dates formula to get the number of days difference between two dates then divide it by a number. For this example, we used Hire and Termination Date from the Employee Details object and divided by 30.
- Try to save the formula and an Error occurs: Text formula cannot contain any operators or condition operators
- If you use only the dates the formula works

### Cause

The system behaviour is as designed.

The error is thrown because in the code we intentionally convert any formula that isn't all the same type into text.

### Resolution

The system behaviour is as designed.

With the current functionality you can achieve the same result, as per the intial formula '(Hire Date – Termination Date) / 30', with the following approach:

- Create a Calculated formula such as 'Hire Date – Termination Date' and save it
- Create an additional calculated column (Date1) based on the previous calculated column (Date). for example, 'Date / 30'
- The formula can be saved without errors.
- You can then decide if to display both or just one column for your report.
- You can then use the calculated column result as you wish.

### Keywords

- Formula
- Calculated column
- Text formula
- Date differences
- operators
- condition operators

### Product

SAP SuccessFactors HCM Core 1605 ; SAP SuccessFactors HCM Core 1608