Just being lazy and not wanting to set up a test BO
I'm trying to do something special when a list of items produces any result which is a multiple of 3 (3,6,9,12 etc), so lets say the number of items returned is 4, would MOD(4,3) give me 1 or 0.333 (it doesn't really matter as long as it's not 0. My formula would then be
IF MOD(Returned results,3) = 0 then do something
1/3 - fail
2/3 - fail
3/3 - pass
4/3 - fail
5/3 - fail
6/3 - pass
and so on
