Skip to Content
0
Former Member
Feb 02, 2012 at 06:39 PM

BW Transformation formula using If in list statement

4763 Views

Hi there, I am trying to create some logic with a transformation formula and nested if statements. I believe that it does not like the IN context. Can someone tell me how to properly state in list as part of below formula?

IF( SUBSTRING( PRDHA, 9, 4 ) IN ( '5004', '5089', '5097', '5119', '5013', '5094', '5099', '5114', '5116', '5125', '5136', '5164', '5171', '5183' ), 'S','B')