CODEWITHSUNDEEP
acumatica
GrayFoxNZ
GrayFoxNZ

Reputation: 361

Calculate Field Get Sum

Hi i'm having trouble finding the correct attribute syntax to calculate the total sum for an unbound field.

Could somebody point me into the right direction?

I have a custom DAC and a unbound field called Actual

Also in my DAC is employeeid, projectid and taskid.

I want Actual to show the sum of the quantities of all project transactions that contain employeeid, projectid etc. Pretty simple right? I know theres a SumCalc but am not sure on how to use it.

Upvotes: 0

Views: 403

Answers (1)

RuslanDev
RuslanDev

Reputation: 6778

There is no attribute in Acumatica to calculate total sum for an unbound field. The PXFormulaAttribute and the PXUnboundFormulaAttribute are designed to always store aggregated value inside a bound field.

To calculate total sum for an unbound field, you should implement FieldSelecting handler as shown in Step 11.8: Calculating the Total Amount of the T300 training course.

Upvotes: 1

Related Questions