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.
Answer
Working out GP %
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.
+10Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
+1In 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.
Ewan ~ Rubech IT ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.