April 05, 2007, 08:23 AM
Patty StoddardHow 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 BPatty
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';