I have a cube with this dimension (eliminate others):
[Document type] (with childs= [Document type].[Devolution] and [Document type].[sale])
And this measures:
And a calculated member:
[Profit] = ([Measures].[Invoiced]-[Measures].[Mfg Cost])/[Measures].[Invoiced]
Unil here all work fine, but a problem has raised; If [Document type] is [Devolution], [Profit] should be 0.
This I've done with:
[Profit] = IIf([Document type].CurrentMember.Name = "Devolution", 0, ([Measures].[Invoiced]-[Measures].[Mfg Cost])/[Measures].[Invoiced])
Wich works ok, but only works for direct member look (Devolution branch). The summarys keep original calculation and no change is reflected.
How can I create this calculated member to put Profit=0 to all devolutions, and reflect this in summary totals too?