Has anyone been able to successfully define 2 conditions on a DEFMACRO?
Currently I'm asking to color a field when less than another field. I would also like to only include this where N4 field is equal to 'O'.


$
DEFMACRO=COND0001,
MACTYPE=RULE,
WHEN=N5 LT N6,

This message has been edited. Last edited by: <Kathryn Henning>,

I can't remember if I've ever tried to do 2 conditions in a when statement, but I have put the condition into a define with an output of "Y" or "N" and then used the result of the define as my WHEN Condition.

DEFINE FILE X
CND /I1 = IF N5 LT N6 AND N4 EQ 0 THEN 1 ELSE 0;
END

TABLE FILE X
PRINT CND NOPRINT
...

DEFMACRO=COND0001,
 MACTYPE=RULE,
 WHEN=CND EQ 1,
$
...
END

Must work.

Great! I'll give it a shot. thank you!

I would rather use a COMPUTE.

Just completed the mods to include the define and it works perfectly.
thank you all for the suggestions.

Conditional styling using WHEN will support evaluation of one condition only. So in case of more than 1 condition, either use DEFINE or COMPUTE(use COMPUTE for better performance).

Thanks,
Ram

Just a word of caution, as I'm just now finding this out after a crap-ton of digging.

I was getting "Unreadable Content" errors in my Excel reports, and I've now narrowed it down to the cause being that if you have

• No records (probably due to a WHEN filter)
  
• A COMPUTE
  
• A DEFMACRO that uses the computed value
  

Most of my reports use EMPTYREPORT=ON (don't ask), but in this case, apparently WebFOCUS can't handle it when the WHEN clause in the DEFMACRO uses a compute field that's blank.

Unfortunately, I can't just set EMPTYREPORT=OFF, because this is the first report in a set of compound reports, and I at least need it to do `FORMAT XLSX OPEN AS report_name`.