Print

[cbrennan]

Hello,

We are using OrgPlus 7.0.
We wish to display the Base Hours Per Day a staff member works.
I export the data from the database as a decimial number.  But it is displayed in OrgPlus as a whole number.
For example, I export 7.5, 4.8, and 1.75 but it shows as 75, 48, and 175 respectively.
It appears to completely disregard any decimal points.

How do I get the decimal numbers to display properly?

Thank you.
Conor E.  C.  Brennan
Applicaiton Support Coordinator

[tkellyj]

If exporting data from Excel, go into Excel and try changing the column that you have your data in to the category text instead of a number, then export it again. Not sure if that will work but doing that sometimes helps me when I'm doing similar things.

[cbrennan]

Thanks for the suggestion, but I am exporting from Oracle.
I have created a view the OrgPlus uses.
The fields in the view contain the proper decimal numbers.

[ChrisL_HC]

Dear cbrennan,

The issue may be that your field is not defined to show any decimal places.  Please follow the below instructions to ensure that your field is set to display decimal digits:

1. Open your chart in OrgPlus 7 and go to Data | Define Fields
2. Find your base hour per day field and click on the Format option for that field (on the far right)
3. Increase the Decimal Digits (second combo box) to 2 (or whatever you prefer) and then click OK, and then OK again

Your fields should now display the correct decimal numbers as opposed to whole numbers.

[cbrennan]

Hello,
Thank you for the directions but is has not worked.
Now I have 75.00 instead of 7.50.

Does anyone else have any suggestions?

Thank you.

Conor E.

[ChrisL_HC]

Conor,

Can you send me your chart with a detailed description of which field you are referring to?  You can send to chrisl@orgplus.com.  Are you doing a calculation with that field?  If so, the logic behind the formula may be causing an issue, or the field may be designated as a percentage.

[cbrennan]

Hello Chris,
I have sent the email.
Thank you for your continued help.
Conor E.  C.  Brennan
Applicaiton Support Coordinator
The Corporation of Haldimand County

[ChrisL_HC]

I was able to meet with Conor and find a work around for the issue:

In Oracle, although the numbers that are displayed are decimal digits, they do not seem to have decimal characteristics (in Oracle, the raw data was a whole number and Oracle converted that to a decimal). When they were brought into OrgPlus 7, they were being seen as whole numbers, e.g., 4.8 is shown as 48, 1.75 is shown as 175, etc. I created two formulas to work around this issue:

- One that divides by 10 if the number is between 9 and 100
- One that divides by 100 if the number is greater 99

This converts 48 to 4.8 and 175 to 1.75, displaying the correct number in the OrgPlus chart.

Subsequently, two additional conditional formats for each conditional format that they had originally setup needed to be created to display the correct field.  Again, these conditional formatting criteria were based on the size of the number.

[cbrennan]

Thank you Chris,
The end user is happy to see the correct data being displayed.
Thank you.

Conor E.  C.  Brennan
Application Support Coordinator
The Corporation of Haldimand County

[ChrisL_HC]

You're very welcome, Conor!