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!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Summing text fields in a view

Status
Not open for further replies.
australia3

australia3

Technical User
Nov 9, 2004
64
GB
I want a column of a view to sum numbers from 2 fields when these fields are text fields. Is this possible?
 
Sort by date Sort by votes
Of course, you can put Formulas in view columns. Of course, you need to transform the text into numbers before adding them, but a simple @TextToNumber will solve that.

Pascal.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MDGarcia
  • Locked
  • Question
Error msg: Network operation did not complete in a reasonable amount of time; please retry
Replies
5
Views
5K
MDGarcia
MDGarcia
P
  • Locked
  • Question
How to run an SPSS syntax from command line?
Replies
0
Views
5K
paulus62
P
MDGarcia
  • Locked
  • Question
Error in onLoad object
Replies
1
Views
5K
pmonett
pmonett
KK_
  • Locked
  • Question
Lotus approach
Replies
0
Views
5K
KK_
KK_
KK_
  • Locked
  • Question
Is there any way to get machine ID
Replies
1
Views
5K
pmonett
pmonett

Part and Inventory Search

Sponsor

Back
Top