Skip to main content
Answer

GI- Calculation formula with aggregate function

  • August 10, 2023
  • 1 reply
  • 323 views
Y
Freshman I
Forum|alt.badge.img

Hi, I am creating a GI and I want to do a calculation with the data field with aggregate function. is there any possible way? the GI XML file in the Attachment. Thank you.

 

The calculation should be SUM([curyLineAmt]) / SUM([curyRevisedAmount])

After the use my formula with aggregate function, it shows this error.

 

 

Best answer by ThasinduRanasinghe61

Did you try adding aggregate function to the GI ?

 

1 Attachments

1 reply

ThasinduRanasinghe61
Jr Varsity I
Forum|alt.badge.img

Did you try adding aggregate function to the GI ?

 

Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved