I want to display the sum of results of a given Value. Ideally I would like to set this to calculate the values over a given period of time, say 4 weeks.

How can I do this please?

Crispin wrote:
Just bumping this in the hope it gets spotted.

Bumpity bump

Seriously, I really could use some advice on how to achieve calculations on the rsform list results

Off the top of my head, I would set up a table (auto-incrementing) in my database, in the form add two hidden fields for date 'submitted' and 'value'. Use the forms 'mappings' to send the field data to my table.
Then add another hidden field in the form and in 'default value' add some custom scripting to pull the data from the database and SUM()....... From WHERE date_submitted BETWEEN CURDATE() AND CURDATE() - INTERVAL ‘1’ MONTH (or 4 WEEK if you prefer)
Then you can use the last field's placeholder in an email or pdf. If you wanted to display it in the form itself then rather than a hidden field use a textbox field.

Something like that anyway but I'm no expert and would be happy to learn about an easier method if anyone can suggest one?

Thank you Iceferret.

Not an expert huh? You sound like you know your stuff to me.

What you suggest does make sense, I shall have a play with it and see if I can get it working.

Thankyou

Definitely no expert but I've been designing a CRUD database membership system for a local club and integrating forms. I've learned a lot about manipulating the data so what you're after isn't a million miles form what i'm doing.