Note: This release is in preview. Features described here don’t become generally available until the latest general availability date that Salesforce announces for this release. Before then, and where features are noted as beta, pilot, or developer preview, we can’t guarantee general availability within any particular time frame or at all. Make your purchase decisions only on the basis of generally available products and features.

round(`n`[, `m`])

Returns the value of n rounded to m decimal places. m can be negative, in which case the function returns n rounded to -m places to the left of the decimal point. If m is omitted, it returns n rounded to the nearest integer. For tie-breaking, it follows round half way from zero convention. n can be any real numeric value in the range of -1e308 <= n <= 1e308. m can be an integer value between -15 and 15, inclusive. This function can only be used in a foreach statement.

If the n value scale is lost on data upload, m can only work with the scale present in the dataset. It can't add scale back to the value.

Note

Example

1q = foreach q generate round(Price, 2) as Price;

Example

1round(-1.2345) = -1

1round(2.355, 2) = 2.36

1round(-3455.8, -1) = -3460

1round(2.35, 3) = 2.35

Analytics SAQL Developer Guide

round(n[, m])

Example

Example

round(`n`[, `m`])