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