Good afternoon - I have a table with dollar amounts in it that is for some reason being recognized as text. I am therefore unable to insert a summary and calculate the SUM because that option is unavailable to me. Is there any way to formal the data for it to be recognized as a number?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
reformatting data in a table 1
- Thread starter helphelen
- Start date
-
1
- #2
fisheromacse
IS-IT--Management
if the contents of the field are all numeric:
tonumber({yourtablename.yourfieldname})
otherwise you can test and only convert numeric values by using:
IF isnumeric({yourtablename.yourfieldname})
THEN tonumber({yourtablename.yourfieldname})
tonumber({yourtablename.yourfieldname})
otherwise you can test and only convert numeric values by using:
IF isnumeric({yourtablename.yourfieldname})
THEN tonumber({yourtablename.yourfieldname})
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question