Split report into Quarters of a Fiscal Year

Question

I wish to break up the number of screenings into different quarters of a fiscal year from July 1 to June 30.

I tried the following but it kept giving me 0.

if {enrollment.date} in {?startdate} to DateAdd("m", 4, {?startdate})
then (DistinctCount ({enrollment.id}))

How can I accomplish this?

Answer 1

create 4 formula fields for quarter clinic
create 4 formula fields for quarter state

-- per quarter formula
if Month (date({Command.mydate})) in 1 to 3 then    --qt1
    <number>
else 0