Question on avoiding exponential format in numbers

Go through below post.
forum.appian.com/.../b-14474

Hi Rahulg262, thanks for the quick reply,
But we tried calculating using fixed, and the results are not proper, In our scenario we cannot take the values to be rounded, we need the exact values while we are calculating. any other inputs please. thanks :)

While calculating you keep using decimal data and use the text() function for formatting.

Thanks Stefanh791 for reply but while calculating it is getting converted into Exponential.

The numbers you calculate on are decimal, right? Then this is just a matter of display. This is why I suggested to use text() for showing the numbers to the user. Try this:

=with(
local!number: 1234567890.1234,
local!number & char(13) &
text(local!number, "### ### ### ###.##")
)

Result is:

1.234568e+009
1 234 567 890.12

Look at the below results. On multiplication of different numbers.

=with(
local!number: 12345679,
local!number*9 & char(13) &
text(local!number*9, "### ### ### ### ###.##")&char(13)&char(13)&
local!number*90 & char(13) &
text(local!number*90, "### ### ### ### ###.##")&char(13)&char(13)&
local!number*900 & char(13) &
text(local!number*900, "### ### ### ### ###.##")
)

Result:

111111111
111 111 111.00

1111111110
1 111 111 110.00

-1773790788
- 1 773 790 788.00

stefanh791: how can we store the value with in the DB ?
Will it store 1.234568e+009 or 1234567890.1234 in the DB ??

As I said before. This is just a matter of how the number is turned into a string when shown to the user. Mathematically they are equal. But as you see in your 3rd result. You cannot save infinity values.

Check en.wikipedia.org/.../Floating_point

What datatype do you use in the DB field? If decimal (float in MySQL) then it will just save the number as it is. If it is text, then it will save "1.234568e+009" by default, because this is how decimal numbers are formatted. You can change that by using the text() function.