キャンセル
次の結果を表示 
表示  限定  | 次の代わりに検索 
もしかして: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
言語を選択 翻訳バーを非表示
MFVIT
Level IV

JSL for converting a formula to its results

Hello,

I have the following jsl code 

 

dt << New Column( "I (%)", (:Mean * 100) );

 

that takes a column (Mean), multiplies by 100 and create a new column called I(%) with the formula.

 

I do not want the formula but just the result of the calculation in the new column. How can I do this?

 

Many thanks.

13件の返信13
MFVIT
Level IV

Re: JSL for converting a formula to its results

Thank you very much, very useful.
MFVIT
Level IV

Re: JSL for converting a formula to its results

Many thanks.

Re: JSL for converting a formula to its results

You do not need a formula at all. I recommend not using column formulas when scripting unless you want the values to dynamically change after the script is done. So your case could be solved this way:

 

dt << New Column( "I (%)", Numeric, Continuous, Values( (:Mean << Get Values) * 100) );
Craige_Hales
Super User

Re: JSL for converting a formula to its results

Cool!

Craige

おすすめの記事