Calculation involving date

[UmarS]

Hi All - I am trying to calculate a new field. the logic is if the sum of count is > 5 in the last 7 days for a particular id then "yes" else" no".
Any ideas.

ID  DATE     Count

1   11/1/2019  1
1   11/2/2019  2
1   11/8/2019  1
2   11/1/2019  2
2   11/2/2019  1
2   11/8/2019  3
3   11/1/2019  3

[DiganP · Accepted solution]

@UmarS You can use the datetimediff function with the multi-row formula tool to calculate the the previous days. You can then use the filter tool to filter out days > 7 and then the summarize tool to aggregate the data. Lastly, the formula tool will help us create the conditional statement (yes/no). Does this work for you?

Attached is the workflow. 

[UmarS]

Great Thanks. It works.