Summing total qty field for all rows for a column on list page

(0) Share

Report

Posted on by AGV

This is on a custom page, for a custom table. The above code is not summing every row in the table, just the row that is selected. This code is the way I envision calculating the sum for a field (outstanding qty), and displaying it in the total qty field. Again, it is just calculating the individual line that is selected though, and displaying that value in the total qty field, instead of summing up every row and calculating the outstanding qty for the entire table.

Any ideas on this would be appreciated. If you do comment, please be specific in your suggestion.

Thanks.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (2)

Suggested answer

DAnny3211 11,397 on at

Like (1)

Report

Hello

excuse me but is KPSAL the same table as the Rec of the page?

once you calculate CalcSums with the KPSAL variable you should assign it to the rec. "total Qty."

rec. "total Qty.":=KPSAL. "Outstanding Quantity"

I don't know if I'm missing something or you can add some more details.

another idea might be to create a flowfield of type Sum with the filter logic you apply in your procedure

DAniele

Was this reply helpful? Yes No
Suggested answer

azharsaeedkhan 60 on at

Like (1)

Report

Try

Rec."Total Qty" := KPSAL."Outstanding Quantity";

Was this reply helpful? Yes No
AGV 65 on at

Like (0)

Report

Hey Danele, I tried that right after this post, and it still did not work. However, that syntax works with other tables/pages because I have done it successful on the sales line page.

I think it is the way the custom table/page is pulling in the values. I did not create the table/page, but it should work the way you described because I have successfully done that on other pages already.

I'll just have to use the calcsums procedure on the sales line page because it is summing up the values in the entire column just fine using that table.

Thanks.

Was this reply helpful? Yes No
Verified answer

AGV 65 on at

Like (0)

Report

Correction, I switched the "Total Qty" field to a variable on the page when trying to resolve before switching the calculation to := KPSAL."Outstanding Quantity", which seemed to be the issue. Below code is correct:

Was this reply helpful? Yes No
Verified answer

Marco Mels on at

Like (0)

Report

Thank you for sharing final solution.

Was this reply helpful? Yes No