Update: I finally got it figured out.
Instead of NOT LIKE, use IN; and combine multiple 'when' in 1 case statement. It seems the formula does not work with multiple LIKE[FONT=Tahoma](‘xxx%’).[/FONT]
I was able to weed out the last Case statement (condition) by using the formula(text) filter.
case when {location} not in ('location1', 'location2') and {createdfrom.location} not in ... and {item.custitem_ite_category} in ('...') then ...
I try to get my head around this complicated CASE statement. My SS tries to calculate the commission at Item level, by Item Category, shippedfrom compared to soldfrom location, has a formula(numeric) case statement as followed:
case when ({location} NOT LIKE 'location1' OR {location} NOT LIKE 'location2') then case when {item.custitem_ite_category} LIKE '32-%' THEN 9 when {item.custitem_ite_category} LIKE '23-%' THEN 9 when {item.custitem_ite_category} LIKE '97-%' THEN 9 else 10 when ({location} LIKE 'location1' OR {location} LIKE 'location2') then case when {item.custitem_ite_category} LIKE '23-%' THEN 4 .... else 5 case when ({location} LIKE &#8216;location1&#8217; AND {createdfrom.location} LIKE &#8216;location1&#8217;) then 0 <em>// i also tried with case when {location} = {createdfrom.location} </em> <em>// how to make this formula as filter? </em> end end end end The "ERROR: field not found" I got when having the "createdfrom.location" statement. Please enlighten me/my head.