I am a complete newbie to Eazy Bi! So apologies if this is a little basic.
I have 2 measures that I defined 'Planned Value and ‘Actual Value’ which I calculated by the following:
What I need is to create first a measure that takes each value and adds it up to a total so rather than getting a set of say 1,2,5 I want it to return 8. So I am having trouble making this calculation, any pointers.
Then once I have a total for each measure I need to calculate what % of the planned value was achieved by the actual value.
It might be worth mentioning the fields return a string.
Any guidance or starting points appreciated!