I was doing it as a running total field (as I did with the 48 hour previously asked).

I broke it up in 2 parts in formula fields:

Formula 1: {Incident.Source} in ["Logged", "Active","Waiting"] came out as false.

Formula 2: whether using :

{Incident.CreatedDateTime} in datetime(year(currentdate),1,1,0,0,0) to currentdatetime

or

{Incident.CreatedDateTime} in yeartodate

These comes out as true.

You know what, I have found the solution to my error.

It seems like I have mixed up a different table from the one I have posted for this issue.

It is now working.


Thanks for your help and I apologize for the mix up!!

count ({Order.OrderID}, {Order.CreateDateTime}, "monthly") ...for month

so what can we count records for current year like same above technique

"yearly" is not working here at the place of "Monthly"


Edited by Vertex - 23 Dec 2009 at 11:52am

Thanks

 "annually" is working here