CODEWITHSUNDEEP
datecrystal-reportsfiscal
Joslyn Sidamonidze
Joslyn Sidamonidze

Reputation: 57

Split report into Quarters of a Fiscal Year

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

by Quarters

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?

Upvotes: 0

Views: 260

Answers (1)

RoMEoMusTDiE
RoMEoMusTDiE

Reputation: 4824

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

Upvotes: 1

Related Questions