Array Error

[IceRuby]

ODBC link to SQL 2000 database. Using Crystal 11

Performing conversion to "hour values" from database so can have crystal perform sum calc.

Formula is
if isnull({t510_payroll_transaction.t510f120_hours}) then 0
else
(
val(split({t510_payroll_transaction.t510f120_hours},":")[1])*60 +
val(split({t510_payroll_transaction.t510f120_hours},":")[2])
)/60

when applying summary receiving error:-
"Subscript must be between 1 and the size of array"

Crystal interprets initial Hours field as String value

Appreciate your help

 

[IceRuby]

Thanks but fixed. Issue created only when applied within Grouping.