Home > IT Answers > Business Intelligence > Convert formula result string to number
TonyMass
5 pts.
 Convert formula result string to number
Crystal Reports 2008, Crystal Reports formulas
My formula produces a string. I want to convert it to a number. Can't use tonumber(@formula).

Software/Hardware used:
Crystal Reports 2008
ASKED: February 15, 2013  7:38 PM
UPDATED: February 15, 2013  7:55 PM
RELATED QUESTIONS
Answer Wiki:
why not?
Last Wiki Answer Submitted:  March 6, 2013  4:33 pm  by  CoSpringsGuy   30 pts.
All Answer Wiki Contributors:  CoSpringsGuy   30 pts. , Michael Tidmarsh   11,410 pts. , TonyMass   5 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Have you tried ToNumber({@formula}) ?

carlosdl
 63,535 pts.
 

Also, it is recommended to check if the string is actually something that can be converted to a number before trying to do the actual conversion.

carlosdl
 63,535 pts.
 

Can’t use tonumber(@formula).
 
Why not?
 
If you don’t tell us what the problem is, we have no way to guess what might work.
 
Tom

TomLiotta
 108,360 pts.