Skip to main content
Answer

When export to excel can not sum value

  • April 29, 2024
  • 4 replies
  • 73 views
V
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

 

4 replies

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

HI

Please use the aggregate function on the GI

 

Acumatica Functional Consultant & Customer Experience Supervisor
Chris Hackett
V
Freshman II
Forum|alt.badge.img
  • vannakheng66
  • Author
  • Freshman II
  • April 29, 2024

HI

Please use the aggregate function on the GI

 

I try but not working 

V
Freshman II
Forum|alt.badge.img
  • vannakheng66
  • Author
  • Freshman II
  • April 29, 2024

HI

Please use the aggregate function on the GI

 

I try but not working 

working

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

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.

Dipak Nilkanth || MVP @2025 || https://www.linkedin.com/in/dipak-nilkanth-293591102 || Acumatica Developer
Chris Hackett
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