Data Connect - Ingested numeric fields return null values in Reporting
search cancel

Data Connect - Ingested numeric fields return null values in Reporting

book

Article ID: 453823

calendar_today

Updated On:

Products

CloudHealth

Issue/Introduction

You may find when importing a dataset via Data Connect that numeric fields appear as null values within reporting, denoted by a - character

Environment

CloudHealth New Experience

Resolution

Ensure that the field in your import dataset doesn't contain characters " encapsulating the value e.g. "9.91" should be listed as 9.91 within the dataset. 

If this is the case update the dataset to remove the encapsulating characters as these should only be in place for values interpreted as strings, doubles require that no encapsulating characters be present.