[SOLVED] Styling on Multiple Conditions of a COMPUTE field
Hi All,
I've seen a number of references to conditional styling using multiple conditions, however nothing I have found refers to conditional styling on a COMPUTE field.
I am computing the GP based on GP Dollars / Sales Dollars. I need to highlight the cell when it is less than 16% (which I am able to do). However, if the cell is 0, it is also highlighted, but I just need this one to remain the same.
So, I need to have 2 conditions (WHERE GP < 16.0 AND > 0);
I can't seem to find where in the Report Painter to make this happen.
Thank you!This message has been edited. Last edited by: jseaburn,
WebFOCUS 7.7.03 Linux / Universe Db HTML/PDF/EXCEL/HTML Active
May 12, 2011, 12:12 PM
davmayf
Compute another var that does your testing and set it to 'y' or 'n' then do your conditional styling on it.
May 12, 2011, 01:55 PM
jseaburn
I thought I had tried that, but I must have done something wrong originally. Anyway, I used your guidance and was able to get it right!
Thank you!
WebFOCUS 7.7.03 Linux / Universe Db HTML/PDF/EXCEL/HTML Active