Skip to Content
Former Member
Jan 27, 2010 at 10:54 PM

Script Logic: Rounding in MDX


Hi Experts,

again I have a question about MDX. How do I round in script logic? In this example I want to round the result of [L_ACCT].[A] - [L_ACCT].<b> and the result of [L_ACCT].[C] * [L_ACCT].[D] - [L_ACCT].<b> as two spaces after the comma so the get compared easier.


[L_ACCT].[#C] = IIF([L_ACCT].[A] - [L_ACCT].<b> = [L_ACCT].[C] * [L_ACCT].[D] - [L_ACCT].<b>, .....)


Can anybody help me here?

Thank you so much in advance,


Edited by: Cora Boettger on Jan 27, 2010 11:55 PM