Formula doesn't work as expected

I want to add a value in new column IBAS Maintenance based on a condition of others columns (see below formula), but the output doesn't work.

For example for Event ID 2955582 I except to see HGPI as values in IBAS Maintenance column instead of UNSC.

ELSEIF Contains([Maintenance],'UNSC') AND Contains([Outage Name],'HGPI')
THEN 'HGPI'

Can you support me? I attach WF and source file.

Thanks

Giovanni

Operation_TBL_TopEvent.xlsx

IBAS report for Event profile.yxmd

Workflow

Accepted answers

RolandSchubert

I seems, [IBAS Maintenance] is 'HGPI' now after running the workflow. Do you want the result in [IBAS Maintenance] or in [Maintenance]?

atcodedog05

Hi @elfunambolo

Same here even i am getting the value as HGPI

Workflow:

Hope this helps : )

IBAS report for Event profile (1).yxmd

All comments

atcodedog05

Hi @elfunambolo

In the data you have given for Event ID 2955582 IBAS Maintenance has value Co hence and means both conditions needs to be met hence its failing. You can use Or if you want to check either of conditions is meeting.

Hope this helps : )

RolandSchubert

Hi @elfunambolo ,

for the Event ID the field [IBAS Maintenance] is "CO", there is no condition in the formula. It's the field [Maintenance] that has the value "UNSC".

Best,

Roland

elfunambolo

Hello, I fixed it changing the column to 'Maintenance', see new WF but issue remain.

elfunambolo

Changed the columns, see WF updated but issue remains

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703