Formula, replacing null with statement

[CherylH]

Hi,

Have a list and adding comments when a line is remove from final output with an error.  Where have I gone wrong in 2nd statement.  Guess I have issue with writing correct statements. 

1st statement works:  Adding column if [LOB]="Facility Services" then "Remove LOB Facility" else Null() endif

2nd statement is malformed statement error even though statement is highlighted correctly:

iF(IsNull([Remove from list] and if [LOB]="International Non-Operating" then "Remove LOB Intl" else [Remove from list] endif

Expected result

WORKS	Does not Work
Statement #1 Adds column and logic or null	Statement #2	LOB	ADDR_LINE_1	CITY_LOCALITY
Remove LOB Facility	Remove LOB Facility	Facility Services	123	Downers Grove
(null)	Remove LOB Intl	International Non-Operating	456	HOUSTON

Thanks in Advance for helping.

Cheryl

[Luke_C]

Hi @CherylH 

Try this, removed the IF after the 'and' and added a parenthesis to the isnull formula

IF  IsNull([Remove from list]) AND [LOB]="International Non-Operating"

then "Remove LOB Intl"

else [Remove from list]

endif

[CherylH · Accepted solution]

Luke,

Now formula goes black after the Then.  Data type is V-String.

IF  IsNull([Remove from list]) AND [LOB]="International Non-Operating"

then "Remove LOB Intl"

Any other idea?

[CherylH]

Luke,

Never mind, I retyped it instead of copying your response and it works.

I was really overthinking the formula.

Thanks for helping