Re: add modulo to the NewFormulaColumn menu - Status changed to: Acknowledged@HolgerSp - Thank you for this suggestion! We have captured your request and will take it under consideration.
Re: add modulo to the NewFormulaColumn menu - Status changed to: Not Planned For NowThank you for this suggestion. We are not currently planning on making this change, but will consider this in a future release.
Re: add modulo to the NewFormulaColumn menuHm, could you please re-consider this wish.
For my case, every second day I have to generate a column formula with modulo.
Are there other Jmp users who could benefit`?
Main application case:
semiconductor industry - determine the sub-position on a wafer (e.g. position inside a lithography "short")
Other application cases:
- to auto-generate a table with x & y coordinates:
start with row number.
x= floor (row/N)
y= modulo(row/N) - check if a number is even or odd
Re: add modulo to the NewFormulaColumn menuHi @ih - I didn't know that custom functions are automatically added to the right click context menu. That's convenient.
This could help a bit.
But what I have in mind here is a universal "modulo" function (like the "Scale Offset" - just for modulo).
If the user clicks on "modulo", a window shows up and the user can enter the number as a second argument for modulo.
Then a formula column should be generated with modulo(columnname, number from the GUI).
It it possible to add such a GIU-Function to the New Formula Column Right click menu?
Re: add modulo to the NewFormulaColumn menuNo I do not know of a way to add a dialog box to the custom transformation formula interface. It might be possible though, that might be a good discussion post.
Note the Transform Category message which make the custom function available in the right-click menu.
Re: add modulo to the NewFormulaColumn menuHi @mia_stephens :
Following @ih 's solution, I asked the community for a way how to add the desired Modulo miniGui to the New Fomula Column right click menu.
Unfortunately, without success: https://community.jmp.com/t5/Discussions/How-to-add-user-defined-mini-Guis-to-the-right-click-new-formula/m-p/596324/highlight/true#M80000
Do you have a specific way in mind how this can be done?
Re: add modulo to the NewFormulaColumn menu@mia_stephens
Re: add modulo to the NewFormulaColumn menuThank you for this additional information @hogi. We have not received other requests for modulo to be added to New Formula Column, and I'm sure you appreciate that the menus of functions can get quite long so additions are carefully evaluated.
If this is something you do regularly, have you considered a scripted solution?
Re: add modulo to the NewFormulaColumn menu - Status changed to: NewHi @hogi , we see you : )
You have many very good suggestions, and in all honesty, it's a bit hard to keep. We do evaluate each request to determine how to best proceed based on current development priorities and backlogs, and it's not feasible or even desirable to address every request.
The intent with New Formula Column is to provide easy access to the most commonly used functions. As you can imagine, the list can quickly grow, making it harder to use this feature as intended. While we've marked this as Not Planned for Now, it is still on our list and we will revisit if there are other requests.
Thank you for your contributions to helping make JMP better,
Mia
Re: add modulo to the NewFormulaColumn menu
If menus of functions get too long how about adding preferences so users can limit what is being shown?
I think scripted solutions could work (sometimes) if you could easily add them all menus (New Formula and so on). And then there is this issue: Creating statistical custom (formula) function which has byVar ,
Option or function to evaluate a custom column formula at once, or cache values between rows .
And the more generic issues with scripting everything where you have to keep them updated over different JMP versions which quite commonly break things and validating them (instead of trusting that JMP has done the validation).
Re: add modulo to the NewFormulaColumn menuTo be honest, I am also a bit surprised that no Jmp user opted for this wish *)
Definitely, there will be many users who will use the new feature 
I agree with @jthi : If there was a possibility to add user-defined functions to the new formula columns menu, everything would be easier/more flexible.
The wish is there, but also without Kudos - which apparently doesn't mean that nobody wants it. It's just because nobody found the wish
https://community.jmp.com/t5/JMP-Wish-List/personal-presets-for-quot-new-formula-column-quot-right-click/idi-p/486676
Let's hope that the wish gets into a future release - even without Kudos ...
Nevertheless, every basic arithmetic operator should already be in the list by default - if necessary: in a submenu. The majority is there **).
Division is not directly available - but indirectly via Scale Offset/Multiplier. So, no issue.
But modulo is completely missing.
Concerning importance:
For C++ the modulo operator was important enough to reserve a character for it. ***)
So, it's definitely not one of those strange functions which you hear and forget - and never use.
*) Could be that the current approach to hide new wishes in the wish list menu is not a good idea.
**) Some while ago I feared that Jmp also kept the multiplication from the right click new formula column menu - but in this case it was just difficult to find it 
https://community.jmp.com/t5/JMP-Wish-List/add-quot-rescale-quot-to-new-formula-column-right-click-menu/idi-p/559438
***)
Single character arithmetic operators in C++:
Re: add modulo to the NewFormulaColumn menu@hogi you can define custom functions that are available in the right-click New Formula Column menu:
Add Custom Functions(
New Custom Function(
"Modulo",
"y=5",
Function( {x}, Modulo(x, 5) ),
<<TRANSFORM category=""></TRANSFORM>
This adds:
Re: add modulo to the NewFormulaColumn menuThanks for the suggestion @ih ! Adding a custom function makes a lot of sense here.
Re: add modulo to the NewFormulaColumn menu@hogi , alas, we've got a lot in the pipeline already and unfortunately we can't act on every request. There are just so many good ideas!
We'll evaluate the mini-GUIs request separately and will add comments on that post. Thanks!
Re: add modulo to the NewFormulaColumn menu@mia_stephens , @ih , yes I agree.
Here is the respective wish:
New Formula Column menu: user-Defined mini GUIs
If such miniGUIs can be added to the new-formula right click menu, wishes like this one here are no longer necessary
Re: add modulo to the NewFormulaColumn menuok, just ping me when you need further info
Re: add modulo to the NewFormulaColumn menu - Status changed to: Acknowledgedadd modulo to the NewFormulaColumn menu☐ cool new feature
☑ could help many users!
☐ removes a „bug“
☐ nice to have
☐ nobody needs it
In the NewFormulaColumn/Transform menu there are many useful functions, but "modulo" is missing:
more wishes submitted by 
Data Blending and CleanupRe: add modulo to the NewFormulaColumn menu@Sarah-Sylvestre , this wish can be closed.
the New Formula column - new entry: draft function in JMP18 is wonderful.
With 2 additional clicks a user can create whatever function is needed.
Thanks a lot for providing the new functionality.
Re: add modulo to the NewFormulaColumn menu - Status changed to: Archived
