Struggling with YTD formula

[pmk16]

I have been trying to achieve the following.

Considering Feb as the beginning of fiscal year,

For i:= 1 to 12 do // i= month 1 - 12
if month=Feb then
%age = Number of employees terminated % Total Headcount of employees for Feb
else
%age = current month %age + previous month %age

 

[Madawc]

Which Crystal? What happens to your formula? What are you testing?

I think you need to group by month. Take a look at Crosstabs, they might give you a simple answer. Failing that, group records by month and calculate percentages.



Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10