PARSING ERROR WHILE USING % IN CALCULATED MEASURE - Analysis Services

Learn Microsoft BI Forum Core Servers Analysis Servic... PARSING ERROR WHILE USING % IN CALCULATED MEASURE

6/26/2009 5:09 AM

PARSING ERROR WHILE USING % IN CALCULATED MEASURE

I am trying to calculate the remainder using mod(%) operator in a calculated member in SSAS. But it is throwing a parsing error.

The formula i am trying to use is [Measures].[Working Time]%60

Please suggest a solution/workaround.

6/27/2009 3:16 PM

Re: PARSING ERROR WHILE USING % IN CALCULATED MEASURE

The % operator doesn't exist in MDX. If you can't do it in the relational tables or the DSV, then use this:

(([Measures].[Working Time]/60) - int([Measures].[Working Time]/60)) * 60

Page 1 of 1