BookmarkSubscribeRSS Feed
BSwid

Occasional Contributor

Joined:

Sep 25, 2018

JMP Alert: Column "Column Name" requires numeric values{4} in access or evaluation of 'Bad Argument'

I am trying to do a an if statement and am getting the error JMP Alert: Column "Column Name" requires numeric values{4} in access or evaluation of 'Bad Argument' where "Column Name" is the name of the column with the formula.

 

Careful, my input column name looks like a formula but it's a column name.  The input column is Numeric, continuous.

 

What am I doing wrong?

 

Here's the formula

If( Num( Abs( :Name( "(Avg Monthly Demand - SAP Corr Forecast)/SAP Corr Forecast" ) ) ) >= 0.25,
	"Red",
	"Green"
)

Here's the input column properties & the error alert.

JMP Question column requires numeric values.pngJMP Question column requires numeric values 2.pngThanks!

6 REPLIES
Thierry_S

Contributor

Joined:

Apr 19, 2018

Re: JMP Alert: Column "Column Name" requires numeric values{4} in access or evaluation of

It is not much but you have the NUM statement after the ABS statement, should it be the other way around?
Thierry R. Sornasse
andersonmj2

Community Trekker

Joined:

May 4, 2015

Re: JMP Alert: Column "Column Name" requires numeric values{4} in access or evaluation of

That is exactly what I was coming to say - I know I occasionally forget to convert a value in a script and get that error.
Jeff_Perkinson

Community Manager

Joined:

Jun 23, 2011

Re: JMP Alert: Column "Column Name" requires numeric values{4} in access or evaluation of

I'm not sure we have enough information to help you here. It would help to see a sample of the data table that you're working with, ideally attached as a JMP data table that we could work with. We really only need the columns in question and only enough data to reproduce the problem.

 

The error message references "Column 70". Is that the column that contains the formula with the If() conditional? If so, is it a Numeric column or a Character column? Your formula is returning character values, "Red" and "Green", so it should be a Character column.

 

Also, you don't need the Num() at all in your formula. Because your "(Avg Monthly...)/SAP Corr Forecast" column is numeric the Abs() function should work just fine and returns a numeric value. The Num() function isn't doing anything. I don't think it's hurting anything but it's not necessary.

-Jeff
BSwid

Occasional Contributor

Joined:

Sep 25, 2018

Re: JMP Alert: Column "Column Name" requires numeric values{4} in access or evaluation of

Thank you for your help.

In building the test file it seems that the error might be on an input column.  

 

JMP Question column requires numeric values.png

BSwid

Occasional Contributor

Joined:

Sep 25, 2018

Re: JMP Alert: Column "Column Name" requires numeric values{4} in access or evaluation of

I'm trying to post the .jmp file but it keeps rejecting my post.  "The contents of the attachment doesn't match its file type."

Highlighted
stan_koprowski

Community Manager

Joined:

Aug 8, 2012

Re: JMP Alert: Column "Column Name" requires numeric values{4} in access or evaluation of

Hi @BSwid,

Sorry about not being able to upload an attachment with the .JMP file extension.

We are aware of the issue and working quickly to resolve.

Until it has been fully resolved you should be able to attach as a csv file.

 

Thanks,

Stan