I want Diaplay Decimal Point Only for 2 number


Actually In nav i’m getting decimal value should be in text,So That decimal I want display only for two numbers after point.Pls give me a soluion…The report only



In which report and which field?

You can use ROUND function to round it to 2 decimals…You can get more details from Help.

You can use FORMAT to convert a value to text. It has an optional second and third parameter that tell the system how to format the text. For example, you could convert a date, 01/02/2011 to January 1, 2011 using the FORMAT function.