This content has been marked as final. Show 2 replies
Check the case sensitivity of the values [Tactic] match 'TV' and 'Radio' and [Week] matches 'WK..' Also try to wrap the variables in your calculation with ZN() function.
1 of 1 people found this helpful
Thanks, Peter. The string in my case statement did not match the data.