Need help in Field calculation

[mskichu]

hi anyone

I have field which stores floating point Numbers. For example, after calculations this field stores the value 25.20 like 25.2 I want to store like 25.20 is there any way I can do it

thanks

mskichu

www.crazytips.com

[RalphL]

Trailing zeros are not stored in number fields. You can make it display trailing zeros by formating the field as a decimal number. If you want to store trailing zeros make it a text calculation. A case function may the easiest way to do this.

[mskichu]

Thanks ralph

I have tried in case structure but I have also find easier way to do this

I have set the property of the field format as two decimal it worked out.

In windows

Right click on the field in the layout

click Number format and set decimal value to 2

anyway thank you very much