Might be easy, but couldn't figure out the solution...
Want to create a calculated member from Amount measure, If member of Account dimension is in certain range (e.g. revenue accounts), then the calculated member value is measure Amount by reversing the sign, otherwise keep the same as Amount.
My problem is I can't provide correct MDX expression for the calculated member. Please help!!!
