Which function follows standard rounding rules in Qlik Sense?

The function that follows standard rounding rules in Qlik Sense is the Round function. This function rounds a number to a specified number of decimal places based on traditional rounding conventions, meaning that it rounds up if the next digit is 5 or greater and rounds down if it is less than 5.

For example, if you round the number 3.456 to two decimal places, the result would be 3.46 because the third decimal place (6) is greater than 5. This behavior is consistent with the widely accepted mathematical principles of rounding.

On the other hand, the Floor function always rounds down to the nearest whole number or to a specified step size, and the Ceiling function always rounds up. The Pick function, however, is used to select a value from a list based on an index and does not perform any rounding at all. Consequently, the Round function is uniquely suited for scenarios requiring adherence to standard rounding practices.