Subscribe Bookmark RSS Feed

Formula : (1) to Numeric (2) get data more simple way

jameskim

Community Trekker

Joined:

May 17, 2012

Hi there~  =)

(1) to Numeric

    I would like to change character value data to numeric value

    could you tell me the way? 

3875_to numeric.jpg

(2) Get data more simple way   (Difficult one)

    How can I get data with more simple formula?

3876_to be simple formula.jpg

I appricate ur help in advance.

1 REPLY
Jeff_Perkinson

Community Manager

Joined:

Jun 23, 2011

Hi James,

The Num() function will convert character strings to numeric values.

3891_JMPScreenSnapz005.png

I don't think I can offer any advice on simplifying your formula.

-Jeff

-Jeff