November 26, 2014, 11:14 AM
jsp_lbfUse of Constants
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
November 26, 2014, 04:03 PM
Bob Jude FerranteHere'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.
December 01, 2014, 01:10 PM
jsp_lbfThank you Bob, I appreciate the help as always.