Jump to content
  • 0

Spotlight Motor Report


ERik Smith

Question

3 answers to this question

Recommended Posts

  • 0

It is most likely that the weights are stored as text instead of numbers. Do the fields show a unit mark (lb or kg)? if so they are definitely stored as text.

 

A formula something like

=Value(Substring('motor'.'weight',' ',1))

 

Should get you a number which can be summed.

 

'Motor'.'Weight' would be the actual record and field names.

 

The next blank (two single quotes separated by a space) is the delimiter of where the number stops. If there is no space and the unit is lb, then it would just be 'l' (that's a lower case L). or 'k' for kg,

 

The 1 is that you want the first block of text.

 

Ask again or post a simple file with your motors in it so we can take a look.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...