Calc help - running total

[aaronhossain]

Hi all,

Need help with a running total calc please.

A form is used to enter name, date and integer hours worked. I want a new element that calculates the total hours worked for this user.

So a SUM of all previous hours worked plus the new field to provide a running total shown in th elist.

Any ideas?

Thanks

 

[troester]

SUM in list: set element's "List view settings"/Calculations

If you want to show the sum of different records in the form you have to fetch these records from the database directly
http://fabrikar.com/forums/index.php?wiki/common-php-tasks/

 

[aaronhossain]

Thanks, I found this setting after I posted! I didn't like the positioning so I created a MySQL view of what I want to display. I then created a list for the view and placed in a side module. Perfect!