P6 API field values do not match P6 Professional, null values
We are using PPM P6 Professional V19.12.0.34128 and I am writing a java app to extract data for use in Power BI dashboards. Most of the data is being exported correctly but there are some fields that are returning null values when the P6 Professional client is showing a value. Some examples of these are SummaryActualTotalCost & SummaryCostPerformanceIndexByCost in the Projects view. If I use the XML exporter or query the values individually the same result applies. Even using the xmlexport demo app displays this behaviour.
How can I debug this as it seems to be an issue with the API?