I want to count how many (FindingTotal) I have done by quarter (dateofaudit) in my report.
I used this formula to get my numbers for the year: =Sum(IIf(Year([dateofaudit])=2011,[FindingTotal],Null))
Now I need to the same but break it down to quarters. How would I convert this to quarters. Thanks!