You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BIP Excel output removing zeros from decimal

Accepted answer


BIP Excel output removing zeros from decimal

Content (please ensure you mask any confidential information):

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:

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!