Sum of a field for all related records on the master

[MarkMayhrai]

Is it possible to have a view which summerizes the vlaue of a currecny field based on a uniquie ID/

[PotatoMato]

Hi @MarkMayhrai. By summarize, do you mean to sum up the currency field based on id?

 

-Potato

[MarkMayhrai]

Yes, that's what i'd like to do.

I can only achieve this using triggers for update, delete and edit and sending the total to another table.

I'd like a way by which a view can be created which will sum and be available as a table set for use.

[Tubby]

AFAIK, views does not have any calculation abilities as it is only used for filtering existing values of the Tables included. A workaround that I can think of instead of using Triggered Actions is to create an Auto-submission form but use a single record update form and receive the ID as parameter. But that would be much slower than triggered actions which happens on the backend instead of the frontend.

This is a reference for auto-submit forms:

 

[NiceDuck]

If you are interested on doing this on a datapage level, I.E. Report datapage, you can use a calculated field/value to get the sum value for you using a select statment.

ex.

Select Sum(value1) from demo_table2 where foreinID=[@field:MyID]