Skip to main content
Solved

Formatting Total Aggregate Function in GI to Match Schema Field

  • June 5, 2025
  • 1 reply
  • 33 views
B
Semi-Pro II
Forum|alt.badge.img+1

In my GI, I have multiple columns using the same schema field to format into whole numbers with commas. However, on the Total Aggregate Function, one maintains that format, while the other two do not. 

 

 

 

The only difference in these fields that I can think of is, the one that is working is a calculated field from this GI, where the other two were calculated on another GI and then brought in as a data source, but I am not allowed to bring over extra schema fields/formatting if I use a GI as a data source.  

 

Does anyone know if there is some way for me to do this? I really wish the total aggregate function just matched the same schema field since it is on the same results grid row….

 

 

Best answer by bodiec

I don’t really know why this issue occurred in the first place,

 

But somehow if you use =[Field] instead of just choosing the data field from the dropdown, it will follow the Schema all the way to the Total Aggregation at the bottom. 

This was my example

 =[ScheduledMonthlyProdItems.ScheduledMonthlyUngrouped_AMProdOper_Formula2e7f9a7fb6d24d139d8b23186fd01317]

1 reply

B
Semi-Pro II
Forum|alt.badge.img+1
  • bodiec
  • Author
  • Semi-Pro II
  • 67 replies
  • Answer
  • October 6, 2025

I don’t really know why this issue occurred in the first place,

 

But somehow if you use =[Field] instead of just choosing the data field from the dropdown, it will follow the Schema all the way to the Total Aggregation at the bottom. 

This was my example

 =[ScheduledMonthlyProdItems.ScheduledMonthlyUngrouped_AMProdOper_Formula2e7f9a7fb6d24d139d8b23186fd01317]


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