Report filtering is not returning data I expect it to

PeggyLang

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.

Ella

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.

PeggyLang

@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.

PeggyLang

@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.

Ella

@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.