Focal Point
How do I combine multiple IF statements

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

April 05, 2007, 08:23 AM
Patty Stoddard
How do I combine multiple IF statements
The following statement works in a define:
IF DETAIL_DOCUMENT_CODE LIKE 'I%' THEN 'Invoice' ELSE 'error'
How do I add addition if statements? For example,
IF DETAIL_DOCUMENT_CODE LIKE 'I%' THEN 'Invoice'
IF DETAIL_DOCUMENT_CODE LIKE 'J%' THEN 'Journal Entry'
IF DETAIL_DOCUMENT_CODE LIKE 'F%' THEN 'Payroll' ELSE 'error'
April 05, 2007, 08:36 AM
Alan B
Patty
It is straightforward, put an ELSE in between your IF statements:

IF DETAIL_DOCUMENT_CODE LIKE 'I%' THEN 'Invoice'
ELSE
IF DETAIL_DOCUMENT_CODE LIKE 'J%' THEN 'Journal Entry'
ELSE
IF DETAIL_DOCUMENT_CODE LIKE 'F%' THEN 'Payroll' ELSE 'error';


Alan.
WF 7.705/8.007
April 05, 2007, 08:43 AM
Patty Stoddard
Thanks a million!