September 22, 2008, 02:15 PM
Mooglemodifying % Rchd loses stoplight
Hi,
I have a case where the target for a measure is $0, but if they have an actual of zero, the % Rchd shows a green stoplight and .0%. The user would like it to show 100%.
I cracked open the TODMEAS1 fex, and found this field in the PASS2 section:
CURR_IND_STAT_PCT_HTML
I modified it to use this formula:
COMPUTE CURR_IND_STAT_PCT_HTML_V2/A150=IF (CURR_ACTUAL EQ 0 AND CURR_TARGET EQ 0) THEN '100%' ELSE CURR_IND_STAT_PCT_HTML;
This works well, except that it loses the green stoplight when it is reset to 100%. My theory is that the original CURR_IND_STAT_PCT_HTML probably contains an image reference, but I couldn't find out where it's being concatenated. I would like to hard code the green stop light in front of the 100%, since it will always be green during those conditions.
Please advise,
Joey
September 23, 2008, 08:22 AM
PBrightwellThe image for your "Stoplight" is probably coded in your stylesheet. If it isn't obvious, look for an INCLUDE or CSS
September 23, 2008, 02:18 PM
Bob Jude FerranteWhen target is 0 in 4.2.1 we always have Pct Reached be 0. Descending Measures with zero target incur funny math. We have to avoid a divide by zero there so we just set Pct Reached to 0.
In V5 PMF has a new feature that lets you set the basis for descending measures with low or zero targets. Apart from that you might want to create your own logic for that circumstance.