This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I tried to apply a formula to categorize many different invoice types. And I appreciate your input:
In SAP raw data, we have different invoices with different invoice number. First two or three digits of the number depicts certain types of invoice. E.g.
invoice number of which first few digits start with:
8xxxxxxxxx invoice type A
44xxxxxxxx invoice type B
49xxxxxxxx also invoice type B
777xxxxxxx invoice type C
001xxxxxxx invoice type D
IF Contains ([test], "8") THEN "invoice type A" ELSEIF Contains([test], "44") THEN "invoice type B" ELSEIF Contains([test], "49") THEN "invoice type B" ELSEIF Contains([test], "777") THEN "invoice type C" ELSEIF Contains([test], "0001") THEN "invoice type D" ELSE "Others" ENDIF
The IF contain formula might also include scenarios where the specific numbers appear within the 10 digit invoice number, not limited to the first few digits.
Maybe I should not use the IF contain formula. Any bright idea here?