decimal value up to 2

[manu1512]

Hi every one , I have one field Pressure .How can i limit the values of these field up to 2 decimal .

I have values like 1485697456 in it.

Regards

Manu

[its_anandrjs]

What is expected output.

[its_anandrjs]

May be

=num( '1485697456','#,##0.00')/100

[vishsaggi]

May be using Num()function like

Num(YourNumberfield, '#,##0.00')

[its_anandrjs]

In load statement, you can try this

Load

Num( Fieldname,'#,##0.00') as NewName

From.....

[sunny_talwar]

Where is the decimal in this number?

1485697456

[manu1512]

Hi Sunny,

The values are like 455,82261

[manu1512]

Vishwarth the values are like 155,882261

[sunny_talwar]

Seems like your decimal separator is a comma, is that right? If that is true, can you check if you have this in your environmental variables

SET ThousandSep='.';

SET DecimalSep=',';

If you do, then this seems to work

=Num('455,82261', '#.##0,00')

[Shubham_Deshmukh]

If you want to restrict values after decimal points

eg. 455.XXXXXXXXXXXXXXXXXXX to 455.XX

Then there are 2ways,

1) Simply go to Properties->Number,enable fixed radio button there & gives your required range.

2)You can use function Round() eg. Round(condition/count, '#####.##')