IF Condition

Question

Hi All,

I'm using simple Formula tool to define a IF Statement where it checks for condition for M1 and M2 and the issue I'm facing is the second Condition is classified into bucket 'OTHER' is there a way to show both M1 and M2 flag under Metrics column.

Attached sample WF.

Thanks

IF Condition.yxmd

binu_acs · Answer

@suby One way of doing this

IF Condition.yxmd

ed_hayter · Answer

With the modified IF statement and the data as is you will get M1 & M2 and Other. If the data changes and there is a record that satisfies M1 and M2 then they will be classified as M1. My logic  does not include anything for assigning just M2 because in order to be M2 you are required to meet the spec to be M1 hence "M1 & M2"

suby · Answer

Thanks so you mean to say I will be getting M1 & M2 and OTHER is that right ?