Solved

Aggregate function in Report Designer

  • 14 February 2023
  • 1 reply
  • 246 views
K
Rank
Userlevel 5
Badge

In Generic Inquiries, we can use Aggregate Functions & Grouping to sum values based on similar key fields, which is a great feature to present summarised data.

Is there a similar way to aggregate rows with the source schema tables in Report Designer? It appears that ‘groups’ in Report Designer refers to grouping sections, and does not appear to perform any aggregation.

icon

Best answer by miguel80 14 February 2023, 20:49

View original

1 reply

miguel80
Rank
Userlevel 5
Badge +1

Hi!

You can either use Variables in the detail section that will calculate the fields that you want to aggregate or you can use the aggregation formulas on the group section:

 

Miguel Q

Reply


Terms & ConditionsCookie settings
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