Does anyone know how to show the GP % total as a % for a group of records by date periods?
The individual lines work across Sales/Profit/GP% but we need a total of the %. We tried AVG (in screenshot below) but it doesn’t work.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/2caec087-9390-4501-a8ae-d33a0790e45a.png)
Does anyone know how to show the GP % total as a % for a group of records by date periods?
The individual lines work across Sales/Profit/GP% but we need a total of the %. We tried AVG (in screenshot below) but it doesn’t work.
In the latest version of Acumatica (2024 R1) you can use GI’s as a data source for a GI.
Therefore you could create a GI to do the grouping and aggregation and use that GI as data source to another GI where you can then calculate the percentage.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.