I am pretty new to eazyBI, could you please help me out with the following
- I have a report, which shows values of the Measure called “Outstanding Value”. Works fine.
- I have a dimension “Outstanding Currency” created from issue link.
- Outstanding Currency dimension members have custom number field called “Rate”, which is imported as Property
What I need to show is Outstanding Value multiplied by Rate.
I created Custom measure:
[Measures].[Outstanding amount due]*[Outstanding Currency].CurrentMember.get(‘Rate’)
It works perfectly when Outstanding Currency is in a row. When I remove Outstanding Currency, it displays nothing.
How do I make easyBI to calculate for each issue its Outstanding Amount * Rate and then let eazyBI aggregate it according to current report setup?