Running total

[moxie]

Been struggling with this (calc learner). I'm trying to set up a calculation that gives me a running total (against each record, so a summary field won't work, or is far to slow) in a found set of records.

I want to then do some testing based on the result, ie. when the total > 32, do not add to the total....

I'm trying to work out annual leave and time in leu that we get in the office.

thanks,

[Søren Dyhr]

Aggregation functions over a cartesian relation seems the obvious answer, but isn't becasue it scales badly:

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000333

...although it's in .fp5 format! Yet another one is this:

http://www.nightwing.com.au/FileMaker/demos8/demo807.html

--sd

[comment]

I am only guessing here, but it seems to me that to solve the REAL problem behind this, a plain (not running) summary field would suffice, with a calculation =

Min ( GetSummary ( sTotal ; breakField ) ; 32 )

[moxie]

Thanks will give it a go, ended up getting it working by pulling the data out of a running summary, then applying the calculations not the cleanest though...