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