Forum Discussion

MathewCrist's avatar
MathewCrist
Qrew Member
4 years ago

Formula that calculates # of lead in past week

Hi, We have a numeric (summary) field that calculates our # of leads (all time). This is a lookup field.  So, if we have 30 leads all time from Facebook, I can easily see that in a report by dis...
Relationships
MathewCrist's avatar
MathewCrist
Qrew Member
4 years ago
Thanks Mark, and so when I do that, I would need to add a formula to the summary field?

If so, I may need some help on what that formula would look like.

Best,

Matt

------------------------------
Mathew Crist
------------------------------
MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
4 years ago
Matthew,

To answer your last question, you would add filters to your summary field. I'm assuming you have a field in your leads table that is something like [Date Lead Acquired].

So your summary field for # of leads acquired last week could be something like:

Number of leads where:

[Date Lead Acquired] is on or after 7 days in the past.
​

------------------------------
Mike Tamoush
------------------------------