Skip to main content
Solved

When export to excel can not sum value

  • April 29, 2024
  • 4 replies
  • 127 views
  • Translate All
Freshman II
Forum|alt.badge.img

When add function in data field and view inquiry. after export to excel but in excel i cannot sum column value

 

Best answer by Manikanta Dhulipudi

HI

Please use the aggregate function on the GI

 

View original

4 replies

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

HI

Please use the aggregate function on the GI

 

Translate
Acumatica Functional Consultant & Customer Experience Supervisor
    Freshman II
    Forum|alt.badge.img

    HI

    Please use the aggregate function on the GI

     

    I try but not working 

    Translate
    Freshman II
    Forum|alt.badge.img

    HI

    Please use the aggregate function on the GI

     

    I try but not working 

    working

    Translate
      Dipak Nilkanth
      Pro III
      Forum|alt.badge.img+14

      Hi @vannakheng66,

      Have you gone through the below link?

      https://community.acumatica.com/reports-and-generic-inquires-115/how-to-include-the-aggregate-field-like-sum-in-gi-export-to-excel-5609?tid=5609&fid=115

      As per @Naveen Boga, we can not export bottom sum fields in Excel. We can export only selected columns in Column Configration.

      Translate
      Dipak Nilkanth || 2X MVP @2025 & 2026 || https://www.linkedin.com/in/dipak-nilkanth-293591102 || Acumatica Developer
        Terms & ConditionsAccessibility 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