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

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

Content

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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