09-28-2022 10:45 AM
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.
09-28-2022 01:25 PM - edited 09-28-2022 01:26 PM
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:
10-04-2022 01:28 PM
Thanks will try! Sorry for the delay i didnt get an email/will check email boxes. This answer only applies to the first scenario, any thought on the second?
11-22-2022 12:17 PM
For the Standard Deviation you may want to simply edit the SQL and run that function directly on the table in the physical schema itself, alternatively you could create and MV and use STD function and curate the MV to support your use case.