HOW TO DO ROUND UP AT DATA FOUNDATION LAYER OR AT BUSINESS LAYER ?

[Former Member]

Dear Expert,

I am using BOBJ 4.0.

I want to do Round off at Data foundation Layer or at Business Layer.

My Column name is XYZ and value is 16.25 means having decimal point. I want to remove decimal point and do round off.

COLUM VALUE	I WANT
16.25	16
16.75	17

Please Help Me.

Regards,

Divyesh Patel

[Former Member]

Hello Divyesh,

Right click the object in the business layer > Edit Dispay format

Under Numeric create a custom format, as shown in the attached snapshot.

Post this change, you will find that data is rounded without decimal values.

Thanks,

Madhumitha

[Former Member]

Dear Madhumitha,

I have made change as per your suggestion, But its showing same decimal point.

When i m doing check Integrity at that time i am getting this Error "THE COLUMN XYZ REFERENCED IN THE TABLE  PQR DOES NOT HAVE THE SAME DATA TYPE AS IN THE DATA TABLE."

Regards,

Divyesh Patel

[Former Member]

Hello Divyesh,

Making the change should give you numbers without decimals. What is the data type of the object at the db?

Regards,

Madhumitha

[Former Member]

Dear Madhumitha,

Data type in db is decimal(32,16).

Regards,

Divyesh Patel

[Former Member]

Hello Divyesh,

In the business layer, what is the data type that is reflecting for the object ? Is it numeric? If not, could you please change it to numeric and create a custom format as mentioned earlier and check the data?

Regards,

Madhumitha