convert characteristic values in key figures in a query
i have a query which provides some key figures and also some probabilties (defined as characteristics). I want to multiplicate the probabilities with the key figures and therefore I need to convert the characteristic values for the different probabilities in key figures.
What is the best wys to do this.
Any help would be great.
Stefan from Munich/Germany
Gillian Leo replied
You need to create a formula variable of your characteristic.
In the Create Formula screen right mouse click on Formula Variable and go through the create process.
The characteristic needs to stay in your query (you can change it's display to No Display) to pass it's value to the formula.
Once you have done this you can use the formula Variable in any other formula.