269489_en-US

liliconcom

Re: how to modify the script from formula(If( :Certified=="Y","Yes",:Actual Progress >= :Target Progress, to formula(If( :Certified=="Y","Yes",:Actual Progress >=( :Target Progress-10%)?

If I am understanding your question properly:

Percent values are stored in JMP as proportions, and displayed as percentages.  Therefore, the numerical value of 10% is .1.  Below is your script modified using the .1 value

New Column( "Target Progress",
 Numeric,
 "Continuous",
 Format( "Percent", 12, 0 ),
 Formula( :Actual Training Time / :Required Period )
);
 
New Column( "Meet Goal",
 "Numeric",
 formula(
  If(
   :Certified == "Y", 
    "Yes",
   :Actual Progress >= (:Target Progress - :Target Process * .1), 
    "Yes",
   "No"
  )
 )
);

how to modify the script from formula(If( :Certified=="Y","Yes",:Actual Progress >= :Target Progress, to formula(If( :Certified=="Y","Yes",:Actual Progress >=( :Target Progress-10%)?

 

Original good script:

 

 

New Column( "Target Progress", Numeric, "Continuous", Format( "Percent", 12, 0 ), Formula( :Actual Training Time / :Required Period ) );

New Column( "Meet Goal", "Numeric", formula( If( :Certified == "Y", "Yes", :Actual Progress >= :Target Progress, "Yes", "No" ) ) );

 

 

target progress is a percent, above script is workabel for old criteria of Actual Progress >= :Target Progress,
but now we want to change to actual>=(target progress-10%) then is ok. Pls checke why below is not work and how to edit below?

 

 

New Column( "Target Progress", Numeric, "Continuous", Format( "Percent", 12, 0 ), Formula( :Actual Training Time / :Required Period ) );

New Column( "Meet Goal", "Numeric", formula( If( :Certified == "Y", "Yes", :Actual Progress >= (:Target Progress - 10%), "Yes", "No" ) ) );

 

 

Scripting