counting last 5 days
Forums
i'm looing for somthing that keeps counting the last 5 days per id.
so from the fifth row, while the id is the same, i add the "amt" but if the "id" changes, it starts again.
for ex.
hi 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,
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
Hi Joshua,
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