WAMOnline Blog

Here’s a quick tip, if you generate calculated members in your code but can’t work out how to format them this is for you..

For some reason Members and Calculated Members have different syntax to format calculated members add them in a similar way to the code here.

<CalculatedMember name="Rolling Budget Margin" dimension="Measures">
<formula>
((([Measures].[Current DAY_ID] / [Measures].[Month DAY_ID])) * [Measures].[Budget Margin])
</formula>
<CalculatedMemberProperty name=”FORMAT_STRING” value=”#,#00;;\Z\e\r\o”/>
</CalculatedMember>