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?
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!