Focal Point
[SOLVED] Styling on Multiple Conditions of a COMPUTE field

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5017007306

May 12, 2011, 11:31 AM
jseaburn
[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