MDX Measure Total in Cube not correct

[Avi]

I have created a MDX Measure on MSP_Portfolio_Analyzer but when I use the
measure in the cube, the total value is not correct. Numbers do not add up.

Help?!

 

[Avi]

This is the expression. It looks like the Total for Planned Work is being
calculated off the expression opposed to a sum of all the values in the
field. That is why the Total of Planned Work is always equal to the Total of
Resource Plan Work.

Planned Work = iif([Measures].[Resource Plan Work]>0,[Measures].[Resource
Plan Work],[Measures].[Work])

any suggestions on how to make the total correct will be greatly
appreciated. thanks!