counting last 5 days

Hi Joshua,

Interesting problem, I should be able to figure it out in a script.  Thanks for posting an image as it helps when trying to create something.  I will get back to you when I have something for you to try.

Brian

Hi Joshua, for your question, is it possible that you can have the same date multiple times for the same ID? or will it always be a separate date per item?

Hi Joshua,

I have something for you but I am waiting to hear if there can be multiple dates for the same ID.  If there is then that complicates the script a fair amount so let me know.

Thanks

Brian

hi Brian,
weird.. i'm almost sure i posted a comment here but i don't see it anymore :|
for every ID there's only one row per date.
the idea is to check for every ID , for the all year (jan- dec ) the amount for seven days in a row ( i notice i wrote 5.. but i ment 7 days )
sorry for the delay and thank you for your help
Joshua

Hi Joshua, just to let you know I haven't forgotten about you.  Work has been quite busy and I haven't had any extra time to complete this.

Hi Joshua,

Here is a script for you to try out.  You have to select the ID, the date fields (needs to be in date format) and the amount.  It creates a sorted database and then calculates the field based on the id and date field.  Let me know if you find any problems with it.

Thanks

Brian

Thank you Brian!
I get this error and the cursor is where the yellow line on the script
Thanks,
Joshua

Hi Joshua,

I updated the file, I forgot to change the hard coded field names for the variables.  I changed that so it should work for you now.

Brian

Hi Brian,
it appears that the "sum" field doesn't do the job well.. look at the image..
on the fifth row the "sum" starts again (instead on the 8 row sums rows 2-8, and  row 9 sums 3-9 and so on..)
 
Thanks again for all your help!!! :)