Problems with Grouping while having Calculated Fields - Acumatica Generic Inquiries & Pivot Tables https://www.augforums.com/forums/acumatica-generic-inquiries/problems-with-grouping-while-having-calculated-fields/ Acumatica User Group Forums en-US Sat, 04 Apr 2026 11:20:10 +0000 wpForo 60 RE: Problems with Grouping while having Calculated Fields https://www.augforums.com/forums/acumatica-generic-inquiries/problems-with-grouping-while-having-calculated-fields/#post-5214 Sat, 28 Sep 2019 12:15:54 +0000 Using a SQL View is the only workaround that I know of, other than writing a bunch of C# code.

Here's an article for more info:

https://www.acumatica.com/blog/technical-tuesday-report-from-sql-view/

]]> Acumatica Generic Inquiries & Pivot Tables Tim Rodman https://www.augforums.com/forums/acumatica-generic-inquiries/problems-with-grouping-while-having-calculated-fields/#post-5214 RE: Problems with Grouping while having Calculated Fields https://www.augforums.com/forums/acumatica-generic-inquiries/problems-with-grouping-while-having-calculated-fields/#post-4987 Tue, 27 Aug 2019 15:13:57 +0000 @royce-lithgo

Ahh got it. Thank you!

]]> Acumatica Generic Inquiries & Pivot Tables Jarrett Eller https://www.augforums.com/forums/acumatica-generic-inquiries/problems-with-grouping-while-having-calculated-fields/#post-4987 RE: Problems with Grouping while having Calculated Fields https://www.augforums.com/forums/acumatica-generic-inquiries/problems-with-grouping-while-having-calculated-fields/#post-4976 Mon, 26 Aug 2019 23:01:00 +0000 You can't perform calculations based off grouped aggregated values in GI.

https://www.augforums.com/augforums/acumatica-dashboards/trend-weighted-average-price-for-purchases-of-specific-item/#post-2321

]]> Acumatica Generic Inquiries & Pivot Tables Royce Lithgo https://www.augforums.com/forums/acumatica-generic-inquiries/problems-with-grouping-while-having-calculated-fields/#post-4976 Problems with Grouping while having Calculated Fields https://www.augforums.com/forums/acumatica-generic-inquiries/problems-with-grouping-while-having-calculated-fields/#post-4973 Mon, 26 Aug 2019 21:22:33 +0000 I have a Generic Inquiry which I have Grouped by ItemClassID, The Fields are as follows: ItemClassID, CuryExtPrice, Calculated Field 1 (Margin $), Calculated Field 2 (Calculated Field 1's Formula/CuryExtPrice)

Everything but the last calculated field seems to be following the grouping just fine, is there something I need to do besides just pasting the formula from Calculated Field 1 and dividing by CuryExtPrice?

DAC's:

 

 

Results Grid:

 

 

Result:

 

 

Thanks in advance!

 

]]> Acumatica Generic Inquiries & Pivot Tables Jarrett Eller https://www.augforums.com/forums/acumatica-generic-inquiries/problems-with-grouping-while-having-calculated-fields/#post-4973