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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Real simple question- numbers

Status
Not open for further replies.

ghostofelmo

IS-IT--Management
Jul 20, 2006
18
US
CR8

I have fields that I am trying to summarize but CR isnt recognizing the numbers. How do I get it to recognize the numbers as numbers?

{P Folder 1.Sq Ft}+{P Folder 2.Sq Ft}+{P Folder 3.Sq Ft}+{P Folder 4.Sq Ft}+{P Folder 5.Sq Ft}
 
If you browse field(in field explorer right click field name) it will tell you if number or string.

If string, then in formula use

tonumber({P Folder 1.Sq Ft})+tonumber({P Folder 2.Sq Ft})+ ...

Ian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top