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?

Is this a cross tab report or normal report – Siva May 26 '17 at 02:56 — Siva, May 26 '17 at 02:56
I should say crosstab should do the trick – RoMEoMusTDiE May 26 '17 at 03:32 — RoMEoMusTDiE, May 26 '17 at 03:32

RoMEoMusTDiE · Accepted Answer · 2017-05-26T02:53:23.210

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

edited May 26 '17 at 02:53

answered May 26 '17 at 02:40

RoMEoMusTDiE

1 Answers1