Hi, I am looking for a way of using the filter function with two conditions.
Example: Looking for a sum of specific accounts and cost centers. lets say for accounts: 400,401 and 406 and from cost centers 21;1000;1150;1321;1400;2321;2400.
I am already using the filter to look for the sum of the accounts, but found out that I need it on specific cost centers as well
Any ideas how to solve this? :)
- Benedikte
Best answer by Franck C
View original
+4
Hey Benedikte,
have you tried using the filter modifier and the “in” operator ? Something like this :
[filter: ‘Cost Center’ in (‘Cost Center’.”21”, ‘Cost Center’.”1000” ,...)] Franck
Hey Franck, thanks! how do I combine the filter for cost center specifications and specific accounts? :)
+4
You can use AND and OR :
[Filter: 'Cost Center' in ('Cost Center'."1", ...) AND 'Account' in ('Account'."404" , ...)]Franck
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.