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

Script Logic: Rounding in MDX

20 Views

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.

*BEGIN

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

*END

Can anybody help me here?

Thank you so much in advance,

Cora

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