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!
Solved! Go to Solution.
Can you share a screenshot
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