Do you have a workbook you could attach?
Doing something like this should work:
TODAY() - [Camera Start Date] + 1
Added one to the denominator as to include the Today in the count.
May this helps: ATTR(DATEDIFF('day', [Camera Start Date], NOW()) )/ SUM([# Hits])
Thanks, Bryce - gave this a go but getting the 'can't divide integer value by date value error that I've seen in a couple of my previous failed attempts. I'll try to upload a workbook.
Wrapping the denominator in parenthesis should solve that. Simple fix (I think!).
(TODAY() - [Camera Start Date] + 1)
It looks like this would work except for the sum function wouldn't give me a distinct sum of the values.
Gotcha. That's why Rahul was smart enough to put it wrapped in an ATTR expression above. Heh.
I've wrapped the # of days within MAX() as it'll be unique per camera anyway (assuming you always have the Camera ID or Camera Start Date in the worksheet rows. Otherwise you'll need to create a LOD expression to be safe). I try to use MIN/MAX instead of ATTR where I know I can as it requires less computing than ATTR.
I want to attach...but saw you were on 10.0 and I'm unfortunately on 10.3. Here's an image nevertheless:
Here are the fields I made:
TODAY()-DATE([Camera Start Date])
Putting them together:
MAX((TODAY() - [Camera Start Date] + 1))
Bryce and Rahul - you guys rock, thank you so much! I had spent hours on this and can't tell you how much I appreciate the help!