Question on avoiding exponential format in numbers

roopeshr over 8 years ago

I have a requirement where I have to perform different type of validations (onscreen) based on calculations that involves 10 digits up to 2 decimal places (ex: 8542137887.12). when I am trying to achieve same using decimal data type it is getting converted into Exponential format. can any one suggest me some workaround?

Note: calculations involve multiplication, division addition and subtraction.

Discussion posts and replies are publicly visible

Parents

0 Rahul Gundu over 8 years ago

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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Rahul Gundu over 8 years ago

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
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data