# How to round off decimal places on Navision reports? **URL:** \ **Category:** Developers Forum\ **Created:** [May 29, 2008, 10:01am UTC](https://www.dynamicsuser.net/t/how-to-round-off-decimal-places-on-navision-reports/19222 "2008-05-29T10:01:25Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![vinodalath](https://avatars.discourse-cdn.com/v4/letter/v/5f9b8f/32.png) [@vinodalath](https://www.dynamicsuser.net/u/vinodalath)\ **Post date:** [May 29, 2008, 10:01am UTC](https://www.dynamicsuser.net/t/how-to-round-off-decimal-places-on-navision-reports/19222/1 "2008-05-29T10:01:25Z")
Hi, Are there any settings to be changed on Navision to round off decimals on reports? For example, the value 10,710.75 should be displayed as 10,710 or 10,711. I tried changing the DecimalPlaces property of textbox from \<2:2\> to \<0:0\> which didn’t worked. Can anyone please advise on how to proceed in this matter? Thanks ---
**Author:** ![Viktoras](https://avatars.discourse-cdn.com/v4/letter/v/e68b1a/32.png) [@Viktoras](https://www.dynamicsuser.net/u/Viktoras)\ **Post date:** [May 29, 2008, 10:36am UTC](https://www.dynamicsuser.net/t/how-to-round-off-decimal-places-on-navision-reports/19222/2 "2008-05-29T10:36:53Z")
You shoud use 0:0 in DecimalPlaces. \<2:2\> is between brackets, because it’s default value. ---
**Author:** ![vinodalath](https://avatars.discourse-cdn.com/v4/letter/v/5f9b8f/32.png) [@vinodalath](https://www.dynamicsuser.net/u/vinodalath)\ **Post date:** [May 29, 2008, 10:45am UTC](https://www.dynamicsuser.net/t/how-to-round-off-decimal-places-on-navision-reports/19222/3 "2008-05-29T10:45:44Z")
I tried this as well, but it didn’t worked. [:(] ---
**Author:** ![Viktoras](https://avatars.discourse-cdn.com/v4/letter/v/e68b1a/32.png) [@Viktoras](https://www.dynamicsuser.net/u/Viktoras)\ **Post date:** [May 29, 2008, 11:41am UTC](https://www.dynamicsuser.net/t/how-to-round-off-decimal-places-on-navision-reports/19222/4 "2008-05-29T11:41:58Z")
I’ve tested - it’s working for me [:)] Another solution - use ROUND(YourDecimal, 1) in SourceExpr. ---
**Author:** ![vinodalath](https://avatars.discourse-cdn.com/v4/letter/v/5f9b8f/32.png) [@vinodalath](https://www.dynamicsuser.net/u/vinodalath)\ **Post date:** [May 29, 2008, 12:32pm UTC](https://www.dynamicsuser.net/t/how-to-round-off-decimal-places-on-navision-reports/19222/5 "2008-05-29T12:32:17Z")
I tried this now. But still the decimals are there. It rounds 64,076.40 as 64,076.00 ---
**Author:** ![Mike\_Spellman](https://avatars.discourse-cdn.com/v4/letter/m/ac91a4/32.png) [@Mike\_Spellman](https://www.dynamicsuser.net/u/Mike_Spellman)\ **Post date:** [May 29, 2008, 3:29pm UTC](https://www.dynamicsuser.net/t/how-to-round-off-decimal-places-on-navision-reports/19222/6 "2008-05-29T15:29:40Z")
Check out the field properties on the table. If the AutoFormatType property is set, this will override the decimal settings. ---
**Author:** ![Xypher](https://avatars.discourse-cdn.com/v4/letter/x/977dab/32.png) [@Xypher](https://www.dynamicsuser.net/u/Xypher)\ **Post date:** [May 30, 2008, 4:23pm UTC](https://www.dynamicsuser.net/t/how-to-round-off-decimal-places-on-navision-reports/19222/7 "2008-05-30T16:23:44Z")
Change the Format property of the Textbox. Set it to… ---
**Author:** ![nunomaia](https://avatars.discourse-cdn.com/v4/letter/n/f9ae1b/32.png) [@nunomaia](https://www.dynamicsuser.net/u/nunomaia)\ **Post date:** [May 31, 2008, 1:54pm UTC](https://www.dynamicsuser.net/t/how-to-round-off-decimal-places-on-navision-reports/19222/8 "2008-05-31T13:54:05Z")
Also check Amount Decimal Places Field in G/L Setup. From Online help. > [@](#): > > This field determines the number of decimal places the program will display (for example, on invoices and in reports) for amounts in LCY. The default setting, 2:2, specifies that amounts in LCY will be shown with two decimal places. ---
**Author:** ![vinodalath](https://avatars.discourse-cdn.com/v4/letter/v/5f9b8f/32.png) [@vinodalath](https://www.dynamicsuser.net/u/vinodalath)\ **Post date:** [June 3, 2008, 7:46am UTC](https://www.dynamicsuser.net/t/how-to-round-off-decimal-places-on-navision-reports/19222/9 "2008-06-03T07:46:17Z")
That works. Many thanks. [:)] ---
**Author:** ![Nethaji](https://avatars.discourse-cdn.com/v4/letter/n/5f9b8f/32.png) [@Nethaji](https://www.dynamicsuser.net/u/Nethaji)\ **Post date:** [August 24, 2011, 4:12pm UTC](https://www.dynamicsuser.net/t/how-to-round-off-decimal-places-on-navision-reports/19222/10 "2011-08-24T16:12:13Z")
Hi vinod, How u set Round off decimal Places Set…ie… In Sales line Table ,unit price is 89.34566 but i Need 89.34 in Report . can U Pls Guide Me. Regards, Nathaji ---
**Author:** ![mohana\_cse06](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)\ **Post date:** [August 24, 2011, 4:26pm UTC](https://www.dynamicsuser.net/t/how-to-round-off-decimal-places-on-navision-reports/19222/11 "2011-08-24T16:26:51Z")
Use ROUND(“Sales Line”.“Unit Price”,0.01) in report sourceexpression ---
**Author:** ![Nethaji](https://avatars.discourse-cdn.com/v4/letter/n/5f9b8f/32.png) [@Nethaji](https://www.dynamicsuser.net/u/Nethaji)\ **Post date:** [August 25, 2011, 5:23am UTC](https://www.dynamicsuser.net/t/how-to-round-off-decimal-places-on-navision-reports/19222/12 "2011-08-25T05:23:18Z")
Thanks Mohan, its Working… [Y] ---
**Author:** ![mohana\_cse06](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@mohana\_cse06](https://www.dynamicsuser.net/u/mohana_cse06)\ **Post date:** [August 25, 2011, 5:49am UTC](https://www.dynamicsuser.net/t/how-to-round-off-decimal-places-on-navision-reports/19222/13 "2011-08-25T05:49:48Z")
Welcome [:D] ---
**Author:** ![kpradeep](https://avatars.discourse-cdn.com/v4/letter/k/f05b48/32.png) [@kpradeep](https://www.dynamicsuser.net/u/kpradeep)\ **Post date:** [November 22, 2012, 11:28am UTC](https://www.dynamicsuser.net/t/how-to-round-off-decimal-places-on-navision-reports/19222/14 "2012-11-22T11:28:35Z")
Hi, It worked for me, thanks for the solution given. Regards Pradeep K