I wonder if someone could tell me the formula that is involved in calculating the % of Tgt for a 'Descending - Lower is better' Measure with 'Use Target Value' for the Calculating % Reached field?
For instance, I have a measure that is setup like this:
Actual: 2,421,665 Tgt: 1,468,493 % of Tgt: [35.1%]
I have tried various formulae, but I can't duplicate the 35.1%.
On a related not, what is the story with 'Basis Value?' You can select it in the Calculating % Reached field, and then it asks for a value. Curious...
JoeyThis message has been edited. Last edited by: Moogle,
-WebFOCUS 8.2.01 on Windows
It looks like the formula being used is:
[Target -(Actual - Target)] / Target
WF 7.65. Solaris. PMF 5.11 on Oracle 10g
|Powered by Social Strata|