This error usually pops up when a report includes columns with numbers that aren’t formatted correctly. To resolve this, you need to convert those columns using a calculation and remove the original versions from the report so Insight can read the data properly.
Which columns can be calculated?
Allowed: Columns with purely numeric values, such as Current Salary and Pension Scheme.
Not Allowed:
Date fields, such as Date of Birth and Pension Start Date.
Mixed-type fields, such as Employee Code, which may contain both numbers and text.
Apply the calculation
Open the report in Edit Mode.
Click Add then click Calculation.
Enter the calculation name, this appears as the column header.
Select the relevant column.
For example, if you select Pension Scheme, the field populates with PECI_PEN_PENSION_PERSON_MERGE.PENSION_SCHEME.
In the Calculation Text field, enter the following calculation:
to_number(nvl([instert column name from step 4], 0), '99,999,999.9999')
Save the calculation then remove the original column from the report.
Once you've done this, only the calculated version remains.
⚠️Important: You need to repeat these steps for every numeric column in the report.