Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

- JMP User Community
- :
- Discussions
- :
- Inserting a self-defined formula in JMP script

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Sep 10, 2018 8:51 PM
(3168 views)

Hi all,

I am actually looking into inserting a formula in the script for every Row available with data, after obtaining the mean of M1-M7 in the summary table.

But somehow, I'm always being prompted with error while debugging. Is there anyway that I can do this better ?

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

The new column syntax is in error. It should be:

```
FE = dt2 << New Column( "FE",
Numeric,
Continuous,
Width( 5 ),
Formula( :M7 - ( :M3 - :M1 - Z ) )
);
```

Jim

2 REPLIES 2

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

The new column syntax is in error. It should be:

```
FE = dt2 << New Column( "FE",
Numeric,
Continuous,
Width( 5 ),
Formula( :M7 - ( :M3 - :M1 - Z ) )
);
```

Jim

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Inserting a self-defined formula in JMP script

Thank you very much for pointing this out, Jim.

Article Labels

There are no labels assigned to this post.