If a user clicks on column/right click/new formula column/Transform/Scale Offset, a GUI pops up and ask the user for the parameters.
After pressing OK, a new column is generated with the respective rescale parameters:
![hogi_0-1675093292777.png hogi_0-1675093292777.png](https://community.jmp.com/t5/image/serverpage/image-id/49629iC57D8C7A96B0280D/image-size/medium?v=v2&px=400)
This is very useful.
I want to add a column/right click/new formula column/Transform/Modulo shortcut to calculate Modulo the same way.
![hogi_1-1675094100698.png hogi_1-1675094100698.png](https://community.jmp.com/t5/image/serverpage/image-id/49631iD8BA7568C1A0ECA6/image-size/medium?v=v2&px=400)
Unfortunately, I don't know how to do that.
In this post @ih suggested to generate a user defined function and use the
<<Transform Category( 1 )
option to add the function to the new formula column menu.
What a cool trick - but I would have to generate individual functions for every number which I want to use as second argument of the modulo function.
Hm.
I hope there is a better solution to get as close as possible to the original idea ...