As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. New TIBCO Community Coming Soon In early summer, TIBCO plans to launch a new community—with a new user experience, enhanced search, and expanded capabilities for member engagement with answers and discussions! In advance of that, the current myibi community will be retired on April 30. We will continue to provide updates here on both the retirement of myibi and the new community launch. What You Need to Know about Our New Community We value the wealth of knowledge and engagement shared by community members and hope the new community will continue cultivating networking, knowledge sharing, and discussion. During the transition period, from April 20th until the new community is launched this summer, myibi users should access the TIBCO WebFOCUS page to engage.
Focal Point    Focal Point Forums    Performance Management Framework (PMF)    [Solved] Descending - Lower is better Measure; % of Tgt calculation?

 Go Search Notify Tools
 [Solved] Descending - Lower is better Measure; % of Tgt calculation?
Guru
 posted June 17, 2009 02:41 PM
Hi,

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...

Cheers,

Joey

This message has been edited. Last edited by: Moogle,

-WebFOCUS 8.2.01 on Windows

 Posts: 318 | Location: Los Angeles, CA | Registered: November 15, 2005 IP
Silver Member
 posted June 18, 2009 08:58 AM Hide Post
It looks like the formula being used is:

[Target -(Actual - Target)] / Target

WF 7.65. Solaris. PMF 5.11 on Oracle 10g

 Posts: 48 | Location: New York | Registered: March 25, 2009 IP