### 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

### Environment

SAP SuccessFactors HCM Suite

### 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 , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , How To