By using this website, you agree to our Terms of Use (click here)
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!
You can't perform calculations based off grouped aggregated values in GI.
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/
Online Members
