Two questions -
1. Round - according to documentation and per our testing round only works to the nearest whole integer. Anyone find a way to round to two decimals (like you can in Oracle SQL developer or excel?)
Ex. 2.5621 in incorta will round to 3 but we want to round to 2.56 as part of an additional calculation
2. Standard Deviation - in oracle it is Std function and stdev.p function
Solved! Go to Solution.
Assuming you want to do this in Analyzer or the Business View you can simply multiply the numeric field by 100 to move the decimals then apply round to the 3rd point of precision determines the rounding up or down, then simply divide by 100 to reset to your 2 decimals as follows: