Hello,
I'm a brand new user. Is it possible to create a Transaction Report with multiple values for Category? I don't see it as an obvious option, but wanted to be sure.
Thanks!
[SOLVED] Transaction Report with Multiple Categories
Moderator: Renato
-
- New User
- Posts: 11
- Joined: Sat Jan 28, 2023 6:31 pm
- Are you a spam bot?: No
[SOLVED] Transaction Report with Multiple Categories
Last edited by KristiB on Sun Jan 29, 2023 8:10 pm, edited 1 time in total.
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: Transaction Report with Multiple Categories
Set the category names via pipe.
- Renato
- MVP User
- Posts: 740
- Joined: Mon Apr 25, 2011 7:36 pm
- Are you a spam bot?: No
- Location: near Zurich
Re: Transaction Report with Multiple Categories
Unfortunately the selection of subcategories does not work then
Renato Forum Administrator
-
- New User
- Posts: 11
- Joined: Sat Jan 28, 2023 6:31 pm
- Are you a spam bot?: No
Re: Transaction Report with Multiple Categories
Thank you! Even though I can't select to include all subcategories, I can pipe the ones I want in. This works great:
Utilities:Internet|Utilities:Gas|Housing
Utilities:Internet|Utilities:Gas|Housing
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: [SOLVED] Transaction Report with Multiple Categories
This syntax is called "regular expressions". Here is an example of searching for some subcategories.
Bills:Telephone.*|Un.*
Bills:Telephone.*|Un.*
-
- New User
- Posts: 2
- Joined: Wed Jan 03, 2024 5:56 pm
- Are you a spam bot?: No
Re: [SOLVED] Transaction Report with Multiple Categories
Hi, this looks great. Could another expression *exclude* specific categories?
-
- New User
- Posts: 2
- Joined: Wed Jan 03, 2024 5:56 pm
- Are you a spam bot?: No
Re: [SOLVED] Transaction Report with Multiple Categories
Solved.
To exclude any categories that contain the string "apple":
^(?!.*apple).*
To exclude any categories that begin with the string "apple":
^(?!apple).*
To exclude any categories that contain the string "apple":
^(?!.*apple).*
To exclude any categories that begin with the string "apple":
^(?!apple).*