We’re asking you to select a content label when starting a new topic in the Discussions area. Read more to find out why.
Choose Language Hide Translation Bar
Highlighted
James_Kim
Level III

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

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 1
Highlighted
Jeff_Perkinson
Community Manager Community Manager

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

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