Skip to main content
Solved

How to get rounded value of decimal value

  • January 8, 2026
  • 6 replies
  • 65 views
V
Freshman I
Forum|alt.badge.img

Hello Experts, i am getting stuck in one of the generic inquiry where total qty is in decimal places so i need to round the decimal value to rounded value. Attached the decimal value .

 

Best answer by aleksandrsechin

Hi ​@vishalsharma49 
Try this formula:
=CInt(Round([ARTran.CuryTranAmt],0))
 


Here is what you will get if the value is 1.2345, for example:

=CInt(Round([ARTran.CuryTranAmt], 0)) → 1

Additionally, if you need:
=Floor([ARTran.CuryTranAmt]) → 1 (rounds a given number down to the nearest integer)
=Ceiling([ARTran.CuryTranAmt]) → 2 (rounds a given number up to the nearest integer)

6 replies

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+16

​@vishalsharma49 https://community.acumatica.com/reports-and-generic-inquires-115/decimal-number-formatting-in-a-gi-to-excel-5175

Acumatica Functional Consultant & Customer Experience Supervisor
    V
    Freshman I
    Forum|alt.badge.img
    • vishalsharma49
    • Author
    • Freshman I
    • January 8, 2026

    ​@vishalsharma49 https://community.acumatica.com/reports-and-generic-inquires-115/decimal-number-formatting-in-a-gi-to-excel-5175

    Hi Manikanta checked this link but i need to round the value not the near  decimal place.

    A
    Jr Varsity I
    Forum|alt.badge.img+4

    Hi ​@vishalsharma49 
    Try this formula:
    =CInt(Round([ARTran.CuryTranAmt],0))
     


    Here is what you will get if the value is 1.2345, for example:

    =CInt(Round([ARTran.CuryTranAmt], 0)) → 1

    Additionally, if you need:
    =Floor([ARTran.CuryTranAmt]) → 1 (rounds a given number down to the nearest integer)
    =Ceiling([ARTran.CuryTranAmt]) → 2 (rounds a given number up to the nearest integer)

      V
      Freshman I
      Forum|alt.badge.img
      • vishalsharma49
      • Author
      • Freshman I
      • January 8, 2026

       

       

      V
      Freshman I
      Forum|alt.badge.img
      • vishalsharma49
      • Author
      • Freshman I
      • January 8, 2026

      Hi ​@vishalsharma49 
      Try this formula:
      =CInt(Round([ARTran.CuryTranAmt],0))
       


      Here is what you will get if the value is 1.2345, for example:

      =CInt(Round([ARTran.CuryTranAmt], 0)) → 1

      Additionally, if you need:
      =Floor([ARTran.CuryTranAmt]) → 1 (rounds a given number down to the nearest integer)
      =Ceiling([ARTran.CuryTranAmt]) → 2 (rounds a given number up to the nearest integer)

      Hi Aleksandrsechin, i tried with the above formula but i am getting error .

       

      A
      Jr Varsity I
      Forum|alt.badge.img+4

      ​@vishalsharma49 
      Review the brackets
      =CInt(Round([INSiteStatusSummary.QtyOnHand]/[AMBomMatl.QtyReq],0))

        Terms & ConditionsCookie settingsAccessibility statement
        About Acumatica ERP system
        Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
        © 2008 — 2024  Acumatica, Inc. All rights reserved