Focal Point    Focal Point Forums    Performance Management Framework (PMF)    Detail question about Measure Entry & Formulas

 Go Search Notify Tools
 Detail question about Measure Entry & Formulas
Master
 posted May 11, 2009 12:11 PM
A user recently emailed us as follows:

In the User Entered Measure ‘Entry Setup’ screen ‘Entry Formulas” it does not seem possible to modify the mapping to

Allow use of a formula for example ACTUAL/D20.2= [Actual * 2]; but rather have to be left as is .

We think this is a point where people can become confused, so we'll shortly post our response as well...

Bob Jude Ferrante
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

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

 Posts: 919 | Registered: March 26, 2003 IP
Master
 posted May 11, 2009 12:17 PM Hide Post
Of course you can. You just have the syntax wrong. What is in square brackets is a virtual field name. Math operations would be outside the square brackets. So correct syntax would be:
`ACTUAL/D20.2= ([Actual]* 2);`

It doesn’t have to be called Actual…
`ACTUAL/D20.2= ([Damaged Units]* 2);`

You can have multiple collected fields
`ACTUAL/D20.2= ([Damaged Units]* [Multi Factor]);`

If you repeat collected fields they are only collected once.
```{note: for actual line} ACTUAL/D20.2= ([Damaged Units]* [Multi Factor]);
{note: for forecast line} FORECAST/D20.2= ([Damaged Units]* [Forecast Factor]);```

What would be collected above, would be Damaged Units, Multi Factor and Forecast Factor.

And you can use formulas and FOCUS functions
`ACTUAL/D20.2= IF ([Damaged Units] LT 0) THEN 0 ELSE [Damaged Units];`

Bob Jude Ferrante
WebFOCUS Performance Management
Bob_Ferrante@ibi.com
917-339-5105

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

 Posts: 919 | Registered: March 26, 2003 IP