Skip to content

ROUND

The ROUND function in Infoveave allows for precise control over numerical data presentation by rounding decimal values to the closest precision.

Applicable to

Calculated Columns

Return Value

The ROUND function returns an integer with the decimal rounded to the nearest precision.

Remark

  • The ROUND function is particularly helpful when dealing with financial data, statistical results, and any other numerical data that require consistent formatting.
  • If precision is greater than 0, the function rounds to that many decimal places.
  • If precision is 0, the function rounds to the nearest integer.
  • If precision is less than 0, the function rounds to the left of the decimal point.
  • ROUND function does not consider nulls and blank values.

Syntax

ROUND(<expression>, precision)

ROUND in Calculated Columns

ParameterDescription
ExpressionA placeholder in a function that is replaced with column names.
Column NameThe name of the column in the dataset or Datasource containing values to analyze.
PrecisionSpecifies the number of decimal places to round the number to.

Steps to Use

  1. Write the ROUND function. For instance ROUND(<expression>, Precision)
  2. Replace <expression> with [Column Name]. Replace Column Name with the actual name of your required column.
  3. Replace precision with the required number of decimal places.
  4. To learn how to add calculated columns in Infoveave, visit the section Calculated Columns.

Example

Objective Consider you have the below sales dataset; your goal is to round the decimal points in the MARKET PRICE column to 2.

ORDER DATECOUNTRYCATEGORYUNIT PRICEMARKET PRICEQUANTITY
2024-01-03BrazilBaby Food38.4143.78742
2024-01-07JapanSpices45.5650.815520
Japan43.787410
2024-01-1832.30194
2024-01-22BrazilCosmetics28.33523.01097
2024-01-26Canada20.18523.01099
2024-01-04FranceCereal25.2628.79649
2024-01-09BrazilCereal44.57550.81558
2024-01-14BrazilSnacks20.1854
BrazilCosmetics40.48546.15292

You can use the ROUND function like

ROUND(VALUE([MARKET PRICE]),2)

The new calculated column “NEW MARKET PRICE” will return the below results.

ORDER DATECOUNTRYCATEGORYUNIT PRICEMARKET PRICEQUANTITYNEW MARKET PRICE
03-01-2024BrazilBaby Food38.4143.7874243.79
07-01-2024JapanSpices45.5650.81552050.82
Japan43.78741043.79
18-01-202432.3019432.30
22-01-2024BrazilCosmetics28.33523.0109723.01
26-01-2024Canada20.18523.0109923.01
04-01-2024FranceCereal25.2628.7964928.80
09-01-2024BrazilCereal44.57550.8155850.82
14-01-2024BrazilSnacks20.18540
BrazilCosmetics40.48546.1529246.15