How to Round Up Decimals

IROUND is a conversion function that allows a double (a number with a decimal place) to be rounded to the nearest whole number.

To convert a decimal to an integer:

• Open a browse on the schema with the column you want to convert by right clicking on it and selecting Open Browse

• Right click in the browse and select Add Column

• Type IROUND( into the Expressions box

• Double click on the Master table and select the decimal column (it will have Double written next to it) then click on Paste

• Finish the expression with )

• The expression should look something like this:

IROUND(MASTER.SPEND)