Hi All,
I need to show and store 7 digits after decimal and before decimal its 'n' number and the data type is number(decimal) how I can do that?
Thanks in advance.
Discussion posts and replies are publicly visible
text(ri!decimal,"0.0000000")
You can use this code to show a decimal number as text with the required format
Thanx for the reply
but it will return text right, I want number decimal to be return will it possible?
todecimal(text(ri!decimal, "0.0000000"))
i think it will work for your requirement
please check
It is taking only this digits
Appian uses double precision floating-point decimal numbers to store your decimal numeric values. Always and in all places!
When Appian displays that value to you, on screen, in a text form, it rounds it to two decimals by default. To change that, you can use the text() function which then returns text.
If you want to modify the underlying data value, use round().