Click here to Skip to main content
15,867,704 members
Please Sign up or sign in to vote.
2.00/5 (1 vote)
See more:
Hi,

I write this formula in Crystal reports.

SQL
sum (tonumber ({Table.totaljoined}))


But getting the error 'field is required'.

After searching i tried this,
SQL
//@TextConvert
If Not IsNull({MyTable,Field}) and IsNumeric({MyTable,Field}) Then
       ToNumber(({MyTable,Field})
Else
       0

The use this in your summary Formula

Sum({@TextConvert})

But again getting error 'string is required here'.


How to resolve this?
Posted
Updated 20-Aug-15 0:07am
v2

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900