I have a questions about calculated members.
All the examples I see do a simple calculation like GM :
[Measures].[Sales] - [Measures].Cost]
What I want is inventory value, like:
[Measures].[QtyOnHand] * [Measures].[AvgCost]
What happens though is that the operations are done in an order that does not give me the desired results. First QtyOnHand and AvgCost are summed/aggregated, and then they are multiplied together - obviously giving me numbers in the trillions.
How can I make a member multiply at the lowest level and sum up the values after multiplying. I could put this value in the fact table, but I thought there would be another way.
Sorry if this basic question has been posed before, but the site's search capabilities are disabled.
Thank you so much!
All the examples I see do a simple calculation like GM :
[Measures].[Sales] - [Measures].Cost]
What I want is inventory value, like:
[Measures].[QtyOnHand] * [Measures].[AvgCost]
What happens though is that the operations are done in an order that does not give me the desired results. First QtyOnHand and AvgCost are summed/aggregated, and then they are multiplied together - obviously giving me numbers in the trillions.
How can I make a member multiply at the lowest level and sum up the values after multiplying. I could put this value in the fact table, but I thought there would be another way.
Sorry if this basic question has been posed before, but the site's search capabilities are disabled.
Thank you so much!