Hi,
I have a chart created and I am trying to count the number of injury, death records for each months.
so i created a formula for months like - if month(date_opened) = 1 then "Jan" else feb and so forth and in another formula for death i have put- if deathfld= "Yes" then 1 else 0 and similarly for injury- if Injury-fld = "Yes" then 1 else 0
Now in my chart i put in the On change of -- Month field and int eh summarized location i put- Count of @Death and below it Count @Injury.
I have put this in the Report Header. For some reason I do not get the counts correct, have been trying a lot, can someone help