BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
jameskim
Community Trekker

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.

0 Kudos
1 REPLY 1
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
0 Kudos