I did try to create a Running Total with a formula in the Evaluate. I first created a Formula with just {Customer.EstDate} called Date2008. Then I created a Running Total on the field on Date2008. Summary was set Distinct Count, under Evaluate I used a Formula Year({Date2008}) = 2008 and Reset the recordson a group. That failed. :)
Â
If that's not what you mean, please clarify.
Â
Jonathan LangÂ
Oil Rite Corporation
Sr. Network Administrator
Ph: (920) 682-6173 Ext: 126
Fax: (920) 682-7699
Â
If that's not what you mean, please clarify.
Â
Jonathan LangÂ
Oil Rite Corporation
Sr. Network Administrator
Ph: (920) 682-6173 Ext: 126
Fax: (920) 682-7699
--- On Thu, 8/13/09, Sean McDaniel <smcdanie@...> wrote:
From: Sean McDaniel <smcdanie@...>
Subject: RE: [Vantage] Distinct Count by Date
To: vantage@yahoogroups.com
Date: Thursday, August 13, 2009, 10:40 AM
Â
Hi Jonathan,
At this point you'd need to do a running total. Within the running total you
can create a formula indicating when to consider the record, when to reset
the count, etc.
Your formula for the running total for 2008 would be something like this
Year(<my date field>)=2008 - this will return a true when the current record
should be evaluated in your distinct count and false when it shouldn't.
From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
Jonathan Lang
Sent: Thursday, August 13, 2009 11:08 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Distinct Count by Date
Good Morning,
I am stuck on what I am sure is an easy solution.
I am writing a report that Lists the Customer.GroupCode then shows a
DistinctCount by Year with the sales of each GroupCode. It Looks like this:
2008
2009
Customer DistinctCount Sales
Distinct Count Sales
GroupA 20 $650,000.00
54 $850,000.
The problem I am having is doing more than one DistinctCount by date. Does
anyone know how to do this or have a formula?
Thanks,
Jonathan Lang
Oil Rite Corporation
Sr. Network Administrator
Ph: (920) 682-6173 Ext: 126
Fax: (920) 682-7699
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]