Reports - Showing Items Rented During a Period but excluding certain categories

isabelle A. shared this question 2 years ago
Answered

Hello

trying to build a report for items rented but i am having trouble with the filter that would exlude certain items like my workers. To do so, i thought of excluding categories with a filter but i can't make it work.

Here is my filter: https://rental.software/account/#/settings/filters/28811

Here is the report: https://rental.software/account/#/settings/reports/74259


thank you

Oldest
  • Oldest
  • Newest

Comments (2)

photo
2

Could you send screen shots? I'm pretty good at the filters but can't use the links to see your filter

photo
1

Thank you for your help.

You can see my filter below. If we take an exemple, my workers ''installateur(s) - démonteur(s)'' are items i do not want in the filter. It as 2 categrories ''main d'oeuvre'' and ''workforce'' .

Then, in my leads section, i ask for the leads for the next 10 days and chose report ''list of items rented'' and apply the filter below and the item ''installateur(s) - démonteur(s)'' are there.... why ?

photo
2

change the OR TO AND

that is what i had to do to get it to work see my filters below


i think the logic is reversed but that is how Tim said to make it work

photo
1

Yes, change to AND because you want to make sure the rentals do not meet any of those requirements


What you are actually telling the computer is :


I want to see it if the rental name does not contain X or if the rental name does not contain Y


So it would show you both X and Y because they are not mutually exclusive


but if you say:


I want to see the lead only if the rental name does not contain X and the rental name does not contain Y


it would show you rentals that do not contain either X or Y

photo
1

So simple ! thank you to both of you.

Also, do you know if i have to add every catagories of an item for it not to show ?

In the exemple i gave you, for the worker, i have the category in French and in English. If i only put the french, will it be excluded ?

photo
1

you will need to exclude it both ways

photo
1

also always post a screen shot because like nicki said, those of us not IO staff cant see your links when you post them on the account level

Glad we could help

photo
photo
1

Here is an exclude filter we use to exclude items from Additional Damage Waiver

It excludes some items individually and some categories totally

To proceed, please choose required action!

Login
Access denied