I have a BIP Data Model and Report with Excel (.xls) as the template type. There are a couple of fields that have zeros at the end of the decimal and for some reason they are being stripped out when viewing in Excel. I want to be able to preserve this.
In the above example, you can see the XML output from the data model is showing the value with the entire value (204.820).
However when I view the downloaded Excel file, this is how the data is displayed:
You can see that the 0 was removed from the end of the decimal.
How can I ensure the 0 is not removed? Is there a specific XML function I can apply to preserve this?