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

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

BSwid — Thu, 01 Nov 2018 21:56:32 GMT

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.

Thanks!

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

Thierry_S — Fri, 02 Nov 2018 00:37:05 GMT

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

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

Jeff_Perkinson — Fri, 02 Nov 2018 13:19:45 GMT

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.

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

andersonmj2 — Fri, 02 Nov 2018 17:18:10 GMT

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.

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

BSwid — Fri, 02 Nov 2018 18:58:19 GMT

Thank you for your help.

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

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

BSwid — Fri, 02 Nov 2018 19:05:06 GMT

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."

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

stan_koprowski — Fri, 02 Nov 2018 19:15:21 GMT

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