Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Distinct Count Running Total 1

Status
Not open for further replies.

codrutza

Technical User
Mar 31, 2002
357
IE
I have GH based on {job} and in Detail I have a formula like this
if month({date}=1) then {job};
I want to count the jobs in RF (or in another GF)
I am inserting a Running Total: Distinct count on this formula and the result is not correct.
I have other formulas on which I have other summary (sum) and they are working ok. Like if month({date}=1) then {sales} and running total (sum) on this works fine.
What am I doing wrong?
Thank you
 
Have you tried a Distinct Count Running Total of {job} when month({date}=1)?



[yinyang] Madawc Williams (East Anglia, UK) [yinyang]
 
So I did.I put month(date)=1 in evaluate /use a formula and seems to work fine.
Thank you very much for your help.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top