Here's a quick tip on defining the measure entry formulas.

Most people don't realize that the measure entry formulas can do more than simple math as stated below.

TARGET/D20.2= [TARGET] + 100 ;

You can actually incorporate all the multitude of the WebFOCUS functions available. If perhaps you want to put a limit on the lowest available target number that could be entered you could simply enter a value to be forced to 80 if a value is entered lower than that.

TARGET/D20.2= IF ([TARGET] LT 80) THEN 80 ELSE [TARGET];

Alternatively if you want you can prevent numbers from being entered as negative numbers by using the WebFOCUS ABS() function.

TARGET/D20.2= ABS([TARGET]) ;

Feel free to try the unlimited number of possibilities.

I hope this helps!
Mike

Additional tips. As Mike says, you can use all kinds of logical operators such as IF THEN ELSE and LT, GT, LE, GE, etc.

Also as Mike says, you can use hundreds of WebFOCUS user functions, as documented in the WebFOCUS docs.

In a lot of senses, this capability is powerful and nearly unlimited.

But there are always limitations. Note that the RECAP type functions will not work since these require reference to data on other rows, and the nature of this is that you're only working with cells intra-row. So no recursion or cross references to values from any other rows. And no plans to allow for these... they tend to be fairly esoteric anyway. You'll have to build a custom app to handle this, or you can use a planning tool like Tagetik (that's really why you're using recursion anyway, right - you're doing planning?).

Questions...
In the recent past, we've had people ask for the ability to enter Y or N or Yes or No in the boxes, because they want to use it for survey type responses. Although theoretically this could work, there is active validation logic implemented in the Measure Entry sheet itself that forces all input to be numeric. Textual entries aren't possible. What this means is right now you have to phrase your Yeses and Nos as '0' for No and '1' for Yes. But they could be in the future... and would work provided you ultimately converted their values to numbers (they must be stored as numeric data ultimately). Is anyone planning to use PMF Measures Entry for this type of work today?