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:
This is very useful.
I want to add a column/right click/new formula column/Transform/Modulo shortcut to calculate Modulo the same way.
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 ...