is there no mod operator in analysis services ?

I am missing a mod (modulo, %) operator in analysis services.

I need to find out if a number is even or not ?
(to return the value in the middle of a set) - and if the tupples in the set is event then the average of the two in the middle.

HANNES

Hi Hannes,

Unfortunately, the MDX language in AS 2000 lacked a "mod" operator, and I'm not aware of it being added in AS 2005, either. Of course, it would be great if someone could contradict; meanwhile, I use this technique:

A Mod B ==> A - (Int(A/B) * B)