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!
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.
Thank you for your help.
In building the test file it seems that the error might be on an input column.
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."
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