I have an If statement that is formed like this:
=if(
(Match([Stage],'Active')) and
(Match([OFFICE_CODE], $(vFilterCode)))
, [Description])
$(vFilterCode) is 'AAA', 'BBB', 'CCC', 'DDD'
It expresses to this:
If((Match([Stage],'Active')) and (Match([OFFICE_CODE], 'AAA', 'BBB', 'CCC', 'DDD')) ,[Description])
I am using this to build a pie chart, however when I load up the pie chart, it appears to filter on Stage = Active and OFFICE_CODE = 'AAA', it doesn't appear to check BBB, CCC, or DDD.
I am sure I have a syntax error somewhere.
Any ideas?
