Skip to Content
0
Former Member
Jun 30, 2009 at 01:20 PM

Crosstab calculations.

9 Views

Good Day,

I've used the formula below to calculate age analysis(0-30Days,31-60Days,61-90Days and Over 90Days) of service calls from the date they were first added,substituting 31-60Days,61-90Days and Over 90Days respectively.

if {CUSTPROB.ADDDTTM} in Aged0To30Days

then {CUSTPROB.SERVNO}

The problem is that for every group total the total is upped by one, in essence, my totals are always out by 4.

Can anyone please help?

Thanks