Trying to sum multiple lines on a GI - and then use that sum within a secondary calculation. Is this possible in Acumatica? I seem to be getting varied results when attempting this per below.
Answer
Can you perform a secondary function on an already aggregated function with GI?
Best answer by yhartman
Hi,
If it helps, instead of selecting a drop down in “Aggregate Function”, you can write the function inline.
Example =Sum([SOLine.CuryUnitPrice]) / Max(InventoryItemCurySettings.RecPrice)
I hope this helps!
Hi,
If it helps, instead of selecting a drop down in “Aggregate Function”, you can write the function inline.
Example =Sum([SOLine.CuryUnitPrice]) / Max(InventoryItemCurySettings.RecPrice)
I hope this helps!
Yisroel Hartman • https://www.linkedin.com/in/yisroelhartman/
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.