Good morning,
I’m having a problem with negative values in merged analyses. When the value is negative and I need to download the CSV file, the values with a negative sign are returned with single quotes in the field.
However, if I export the analysis individually without merging, the negative values appear correctly, without quotes.
Does anyone know how I can proceed?
Hey @danilosilva
If you are facing an issue where negative values are displaying or exporting with a single quote (e.g., ' ) in your merged analyses, it is likely because the system is interpreting the column as a text field.
To resolve this, you can create a new Calculated Field and convert the field back into a true numeric value using the formula below:
CAST(your_field_name AS NUMBER) * 1
(Just be sure to replace your_field_name with the actual name of your column.)
This will successfully convert the data type, remove the single quotes, and ensure your numbers export correctly into your CSV files.
