Round-off Decimal Fields

Description: Round-off Decimal Values to lower precision.
Available Filters: All Events, Event Type, Event Field.
All Fields, Field Name, Field Value.
Settings: - Rounding Mode: This can be Round Up, Round Down, Round Half Up, Round Half Down, Celing and Floor. The rounding mode is applied in conjunction with the decimal scale.
- Scale: The number of decimal places to retain after rounding. Not applicable for Ceiling and Floor modes.

Read Rounding Modes.
Transformation Considerations: Scale is defined for all rounding modes except Ceiling and Floor.

Sample Transformation

Event Type = ad_insights_platform_device and Event Field Name = cpm.

Rounding mode = Floor.

The value of cpm is rounded off using the Floor rounding mode.

Round-off decimal values

Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Nov-10-2022 NA Created as a new document.
Last updated on 29 Nov 2022

Tell us what went wrong