Skip to main content
Answer

Report designer rounding down whole numbers

  • November 12, 2024
  • 4 replies
  • 134 views
A
Freshman II

Hi all

I need to round down values in report designer. Say a customer owes $1076, we need it to show as $1000 only. Please advise

Best answer by arthia

Hi @Andre17 , We have to calculate the number of digits in a variable dynamically and then we can round it off. Please use the below formula

To calculate number of digits in a variable:

PadRight( '1', Len([YourAmountField] ), '0' )

Use the below formula to roundoff:

= Floor([YourAmountField] / (CInt(PadRight( '1', Len([YourAmountField] ), '0' )))) * (CInt(PadRight( '1', Len([YourAmountField] ), '0' )))

 

    4 replies

    DipakNilkanth
    Pro III
    Forum|alt.badge.img+13

    Hi @Andre17,

    You can use below formula.

    = Floor([YourAmountField] / 1000) * 1000
    Hope, it helps!

    Dipak Nilkanth || MVP @2025 || https://www.linkedin.com/in/dipak-nilkanth-293591102 || Acumatica Developer
    Kandy Beatty
    craig2
    A
    A
    Freshman II
    • Andre17
    • Author
    • Freshman II
    • November 12, 2024

    Hi Dipak - will try that. My amount field is a variable on the AR statement =$OrganizationBegBalance

    DipakNilkanth
    A
    Varsity I
    Forum|alt.badge.img+3
    • arthia
    • Varsity I
    • Answer
    • November 14, 2024

    Hi @Andre17 , We have to calculate the number of digits in a variable dynamically and then we can round it off. Please use the below formula

    To calculate number of digits in a variable:

    PadRight( '1', Len([YourAmountField] ), '0' )

    Use the below formula to roundoff:

    = Floor([YourAmountField] / (CInt(PadRight( '1', Len([YourAmountField] ), '0' )))) * (CInt(PadRight( '1', Len([YourAmountField] ), '0' )))

     

    jinin
    Chris Hackett
    A
    Freshman II
    • Andre17
    • Author
    • Freshman II
    • November 15, 2024

    Hi @Andre17 , We have to calculate the number of digits in a variable dynamically and then we can round it off. Please use the below formula

    To calculate number of digits in a variable:

    PadRight( '1', Len([YourAmountField] ), '0' )

    Use the below formula to roundoff:

    = Floor([YourAmountField] / (CInt(PadRight( '1', Len([YourAmountField] ), '0' )))) * (CInt(PadRight( '1', Len([YourAmountField] ), '0' )))

     

    Thank you - excellent formula!!

    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