Skip to main content
Solved

Working out GP %


Forum|alt.badge.img

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.

View original
Did this topic help you find an answer to your question?

3 replies

aaghaei
Captain II
Forum|alt.badge.img+9
  • Captain II
  • 1169 replies
  • June 20, 2024

@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.


ejmillar
Varsity I
Forum|alt.badge.img+1
  • Varsity I
  • 55 replies
  • Answer
  • June 21, 2024

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.


Forum|alt.badge.img
  • Author
  • Freshman I
  • 24 replies
  • June 21, 2024

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings