Math MOD function

[nmuppa]

how to implement MOD (math) functionality in Snaplogic in different
queries as well as using functions

[SpiroTaleski]

@nmuppa

You can use the mod(“%”) operator.

[ForbinCSD · Accepted solution]

@nmuppa - you mentioned queries.

Exactly what are you looking for here?

“%” is the modulus operator in JavaScript, Ruby, and Python.

If you really mean “queries,” which database system are you querying?

Microsoft SQL Server uses the % operator as well, AFAICR.
Oracle and PostgreSQL use a MOD() function.
MySQL uses a dyadic MOD operator (dividend MOD divisor).
Other DBMSes may use something entirely different, like “remainder”.

Or did you really mean you want to implement a modulus function? From scratch?