Data Cleansing

[VeronicaElse]

Hi,

I have a formula in place where [Program] NOT IN ('01','04','05') then 'program error', the excel report does have the leading zeros 01, 05, 04 and it is a V string. When I run the workflow it states program error? I do have data cleansing to remove leading and trailing white space. is that what is causing it? Any ideas?

thanks!

[Luke_C]

Can you share a screenshot

[binu_acs · Accepted solution]

@VeronicaElse I am getting the result properly. Can you compare with your workflow ?

[VeronicaElse]

Thanks for replying-I have a huge formula so it keeps going in this pattern -elseif [Plan Co] not in ('16','15','K3','K2') then 'plan code error' elseif -------- etc etc and  I end it with --else Null() endif