I have created a table of finance transactions, and filtered on about a dozen G/L accounts using the 'in list' operator with | between the accounts. I am needing at add an additional filter on the field 'Closing Entry'. I had already deployed the filter on the account numbers and this was working fine…
So in the data selection i selected 'closing entry' and the operator not equal and in the value field I entered 1….. It does not seem that both filers are sticking, when i redeployed my cube all the accounts were returning (but the closing entry values did not return) in SQL it would be the equivalent to
Select * from
FinanceTransactions where
GLAccountNo. in (1,2,3,4,5,6,7,8)
and ClosingEntry<>1
How do i get the Data selection wizard to understand the 'and' operator when filtering on multiple conditions?
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
Please post this under the General Discussion forum in the Jet Enterprise section of the community site. Folks from Jet Enterprise monitor that forum and should be able to help you out.
Regards,
Hughes
Please sign in to leave a comment.