The String is non-numeric

building reports crystal reports
1

Hi All,

I keep getting an error message that states “The String is non-numeric” for the following formula:

Sum ({@TIME_RECORDED},{USERS.USER_NAME} )/ToNumber(Maximum ({PRODUCTIVITY_LOG.PRODUCTIVE_HOURS},{USERS.USER_NAME}))

Can this formula be fixed to not get this error?

Thanks.

sapwebintelligence (BOB member since 2016-07-27)

2

what is the data type of timerecorded field. if it is not number then change into val… if it is number change to cdbl(fieldname) … instead of putting total details in formula use only left side value one time and then check if it works fine that means the problem in second side field… also check whether your groups available with those names… in both ways you need to convert strings into numeric types… depening on backend information you have to use the fields. …

surya.g :india: (BOB member since 2009-11-24)