 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Conditional Formatting - no data
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Conditional Formatting - no data Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] Conditional Formatting - no data | Login/Join |
| Gold member |
I'm having an issue where I'm including a conditional format in a report, but the conditional format is not only being applied to the values that it should be, but also to those values that are "No Data". For example, I'm coloring data red when it's over a certain percent. TYPE=DATA, ACROSSCOLUMN=N1, BACKCOLOR=RED, WHEN=DFWI_RATE GE EVAL_RATE, $ This code results in certain cells over 20% and other over 30% to be shown in red. But it's also coloring all my "No Data" cells red. DFWI_RATE is a D5.2% field.This message has been edited. Last edited by: Egon, WebFocus App Studio 8.1.0.5, Windows 7 64bit. | ||
|
| Expert |
I would suggest moving the test into a COMPUTE or DEFINE, and set a Flag to say Y or N, and have the test also take into account the MISSING data. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Expert |
The quickest way to solve this is to compute a column which is then used in the stylesheet, something like: ... COMPUTE CONDITION_RED/A3 = IF DFWI_RATE IS MISSING THEN 'NO' ELSE IF DFWI_RATE GE EVAL_RATE THEN 'YES' ELSE 'NO'; NOPRINT ... TYPE=DATA, ACROSSCOLUMN=N1, BACKCOLOR=RED, WHEN=CONDITION_RED EQ 'YES', $ ... Francis  Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Gold member |
Well that was just way to easy, thank you both! That's Monday brain for you. WebFocus App Studio 8.1.0.5, Windows 7 64bit. | |||
|
| Expert |
That were I have the advantage, its Tuesday.....  Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Expert |
That's one of the first set of posts that I have seen where the first shown was posted one day before the next post! Waz posted on Tuesday where as Francis posted on Monday, but only a minute later! That's going to mess with your head!  T
| |||||||||
|
| Expert |
I just entered the pub while he just left. Francis Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Expert |
Something you said? T
| |||||||||
|
| Expert |
Muhahahah. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Conditional Formatting - no data
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SOLVED] Conditional Formatting - no dataCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |