Hi, I think it would be useful to document the modulo function (%). I couldn't see any mention of it in the Math function reference list. I find it very useful for filtering: for example in a database of my orchestra's library of works, I can get a list of composers whose anniversary (multiples of 50 or 100 years) it will be next year by creating a filter field containing the following:
if (year(now()) + 1 - year(Born)) % 50 = 0 or (year(now()) + 1 - year(Died)) % 50 = 0 then
I agree.. the documentation is lacking! Thanks for pointing this function out.. I can use it!