Skip to main content
Solved

Working out GP %

  • 20 June 2024
  • 3 replies
  • 28 views

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.

 

 

3 replies

aaghaei
Rank
Userlevel 7
Badge +9

@astramathis30 The short answer is we cannot have a calculated value in the aggregation based on the other fields value. It is one of the known limitation of GI.

Reza 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*.
ejmillar
Rank
Userlevel 5
Badge +1

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.

Ewan ~ Rubech IT ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
A
Rank
Userlevel 1
Badge

@ejmillar  Thankfully we are upgrading within a couple months. For now, we decided to use Velixo and combine the whole request.

Reply


Terms & ConditionsCookie settings