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

Question

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!

stan_koprowski · Answer

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

BSwid · Answer

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

BSwid · Answer

Thank you for your help.

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