+16
Hi. I've created a calculated column in SF and used the domain NUMERIC(16,8) .. however apparently doesn't look to there.. it makes it NUMERIC(38,7).. however this calculation has 8 behind the decimal. How do I make it at least a precision 8?
Best answer by Erwin Ekkel
View originalThe domain is based on the input. What columns (data types) are used in the calculation and what is the calculation used as input for the column?
+16
The domain is based on the input. What columns (data types) are used in the calculation and what is the calculation used as input for the column?
It use percentage NUM(8,2)
round(power(((taxa_de_juros/100.0)+1.0)
,(1.0/252.0)),8)
The domain for the calculated column is determined by SQL server, not by the SF. Apparently the calculation result only has 7 digits, I tried several numbers and indeed it always returns 7 digits:
+16
The domain for the calculated column is determined by SQL server, not by the SF. Apparently the calculation result only has 7 digits, I tried several numbers and indeed it always returns 7 digits:
Ah, didn't see that… well the answer than is to force a cast to float of the POWER elements.. then I get my 8th digit.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.