Report filtering is not returning data I expect it to
I have a very simple report with 2 filters applied.
The above should return 10 items, however, it returns none. If I remove the second filter (PC#=0001) then report is populated with ALL items where 'Expense Type=Exp'.
The cell containing the '0001' (PC #) is a calculation - not sure if that would make a difference.
Any help would be greatly appreciated.
Answers
-
Hi @PeggyLang , the easiest way to see if that's the issue is to create a temp column and manually type 0001 and see if the report pulls it.
-
@Ella changed the calculation to an input of '0001' - did not work.
I tested changing the filter from 'and' to 'or' and result we ALL items where Expense Type=Exp were pulled.
I really need the ability to isolate Exp items for individual locations.
-
@Ella I just changed my filter to the below;
ThIS worked! Still don't understand why the 'PC#=0001' did not work (and I would like to figure that out), but I at least figured out how to get the info I needed.
-
@PeggyLang glad you figured it out. If I have to guess it most likely does not like the leading zeros and the condition of equals 0001.
