Hi All

It might be a simple question and I am not aware of the answer.

is Nested IF, THEN ELSE possible within a DEFINE in InfoAssist+

As always, your responses are highly appreciated.

This message has been edited. Last edited by: NewBee...WF8,

Yes.

  

-*COMPONENT=Define_CAR
DEFINE FILE CAR
IF_THEN_ELSE/D12.2M=IF COUNTRY EQ 'ENGLAND' THEN CAR.BODY.SALES ELSE IF CAR EQ 'DATSUN' THEN SALES * 10 ELSE 0;
END
ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
SET SQUEEZE=ON
-DEFAULTH &WF_HTMLENCODE=ON;
SET HTMLENCODE=&WF_HTMLENCODE

SET HTMLCSS=ON
-DEFAULTH &WF_EMPTYREPORT=ON;
SET EMPTYREPORT=&WF_EMPTYREPORT

-DEFAULTH &WF_SUMMARY='Summary';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
TABLE FILE CAR
SUM CAR.BODY.SALES
IF_THEN_ELSE
BY CAR.ORIGIN.COUNTRY
BY CAR.COMP.CAR
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET GRWIDTH 1
ON TABLE SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, ORIENTATION=LANDSCAPE, $
ENDSTYLE
END

-RUN

This message has been edited. Last edited by: BabakNYC,

quote:

Originally posted by BabakNYC:
Yes.

  

-*COMPONENT=Define_CAR
DEFINE FILE CAR
IF_THEN_ELSE/D12.2M=IF COUNTRY EQ 'ENGLAND' THEN CAR.BODY.SALES ELSE IF CAR EQ 'DATSUN' THEN SALES * 10 ELSE 0;
END
ENGINE INT CACHE SET ON
SET PAGE-NUM=NOLEAD
SET SQUEEZE=ON
-DEFAULTH &WF_HTMLENCODE=ON;
SET HTMLENCODE=&WF_HTMLENCODE

SET HTMLCSS=ON
-DEFAULTH &WF_EMPTYREPORT=ON;
SET EMPTYREPORT=&WF_EMPTYREPORT

-DEFAULTH &WF_SUMMARY='Summary';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
TABLE FILE CAR
SUM CAR.BODY.SALES
IF_THEN_ELSE
BY CAR.ORIGIN.COUNTRY
BY CAR.COMP.CAR
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET GRWIDTH 1
ON TABLE SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, ORIENTATION=LANDSCAPE, $
ENDSTYLE
END

-RUN

Thank you BabakNYC for the example and a quick response. Appreciate it.