HI all,
I m a newBee to MSAS i want to apply the modulus operator in a
calculated member formula but apparently the '%' is not allowed in a
calculated member formula and i could not found any other means to
emulate the modulus function.


Thank You

Maybe an approach like in this post can work for you:

http://groups.google.com/group/micro...olap/msg/8b4d8
b145090b951

From: Priya
Date: Wed, Dec 18 2002 5:40 pm
Groups: microsoft.public.sqlserver.olap

Hi,
there is no direct modulo function in analysis services.
However, you could use the Int function to get the
quotient part and then use that to get the remainder part.
For instance,
Int(7/3) returns 2 (the quotient part)
7 - (Int(7/3)*3) would return 1 .....like 7%3 returns 1.
The Int function can be used in the editor for calculated
measures.
Hope this helps!
Priya


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***