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.
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.
Best answer by ejmillar
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.