Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    [Solved] Descending - Lower is better Measure; % of Tgt calculation?
Go
New
Search
Notify
Tools
Reply
  
[Solved] Descending - Lower is better Measure; % of Tgt calculation?
 Login/Join
 
Guru
posted
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: 319 | Location: Los Angeles, CA | Registered: November 15, 2005Reply With QuoteReport This Post
Silver Member
posted 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, 2009Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  Performance Management Framework (PMF)    [Solved] Descending - Lower is better Measure; % of Tgt calculation?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.