Turn on suggestions

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

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- If/Random Int Formula Question

Topic Options

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

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

If/Random Int Formula Question

Nov 12, 2015 8:36 AM
(1444 views)

Hello,

I am trying to get a formula to work for a dataset, but I'm having problems. I have the formula set up so that:

But this returns 1 for all columns. What am I doing wrong?

3 REPLIES

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

Re: If/Random Int Formula Question

Nov 12, 2015 10:02 AM
(1374 views)
| Posted in reply to message from benson_munyan 11/12/2015 11:36 AM

Hi, Benson!

Try a Comma(,) instead of the LessThan(<) symbol in the Random, Integer function.

Alternatively, try not holding down the Shift key when you type the Comma.

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

Re: If/Random Int Formula Question

Nov 12, 2015 10:30 AM
(1374 views)
| Posted in reply to message from benson_munyan 11/12/2015 11:36 AM

Try replacing the less than sign with a comma (15,26)

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

Re: If/Random Int Formula Question

Nov 12, 2015 10:35 AM
(1374 views)
| Posted in reply to message from benson_munyan 11/12/2015 11:36 AM

Try a comma instead of the less-than symbol between the numbers. The above returns a random integer between 1 and 1 (because 15 is less than 26. Every time)

To enable the optional second argument in the formula editor, select the square within parentheses and click **^.**