Skip to main content
Solved

GI- Calculation formula with aggregate function

  • 10 August 2023
  • 1 reply
  • 135 views

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(McuryLineAmt]) / SUM(McuryRevisedAmount])

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

 

 

1 reply

Userlevel 2
Badge

Did you try adding aggregate function to the GI ?

 

Reply