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

Facebook Twitter LinkedIn YouTube
Go
New
Search
Notify
Tools
Reply
  
Use of Constants
 Login/Join
 
Gold member
posted
In legacy releases of PMF, we used a technique for percentage measures to ensure an accurate rollup when looking at yearly & quarterly summaries. For example, I have a measure called Bookings GP Pct, and when computing the actual value, I would use the following fields from my source table:

Actual Numerator = Bookings_GP_Actual_Dollars
Actual Denominator = Bookings_Sales_Dollars

This computes the GP Pct accurately and also translates perfectly into 5.3.2 using the new measure setup methodology.

However, I previously calculated the target percentage this way:

Target Numerator = Target_Bookings_GP_Pct
Target Denominator = TARGET_DENOMINATOR/D20.2=1;

I would change the selection from field to code and input the above formula, basically to mimic dividing by 1, since the target pct was already calculated and stored in my source table.

I cannot figure out how to replicate the procedure in 5.3.2, baslcally I want to enter a constant of 1 for the denominator instead of entering a datapoint name for the target.

Any suggestions welcome.

Thanks in advance.

WebFOCUS 7.7.04m/PMF 5.32 HF 4 ,Tomcat,IIS,Windows/iseries,sql server 2005,Excel/ PDF/HTML
 
Posts: 60 | Registered: December 30, 2008Reply With QuoteReport This Post
Master
posted Hide Post
Here's how to do it.

Create a new Derived Datapoint.

Use a formula like the following:
Target_Bookings_GP_Pct - Target_Bookings_GP_Pct + 1

You can name this Derived Datapoint something simple like Averaging Denominator, or even Constant 1.0

In the future we will support pure constants with a little less work.

Hope this helps.


Bob Jude Ferrante
Director of Business and Development
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

I'll take any questions about PMF - business or technical - anytime!

 
Posts: 916 | Registered: March 26, 2003Reply With QuoteReport This Post
Gold member
posted Hide Post
Thank you Bob, I appreciate the help as always.
 
Posts: 60 | Registered: December 30, 2008Reply With QuoteReport This Post
  Powered by Social Strata  
 


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