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 Number Format

edited Nov 27, 2018 3:38PM in General Transactional Reporting (OTBI) 2 comments


Hi all - I have a BIP report we use for absences.  An employee can have absence duration, for example, of 1 or .015 (depending on how they are taking their time). 

If I have the report display those columns in text, it will display 1 and .015 fine, but then I have to convert to number on export. 

If I have it display as a number, it will display based on the number of decimals I choose.  I do not want the report to display duration of 1.000 in order to get the .015 displaying properly as a number.

The report was built by building the data model and then clicking on "Create Report" to build the report with the Report Editor.  We did not upload/use any templates.


Howdy, Stranger!

Log In

To view full details, sign in.


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