Report filtering is not returning data I expect it to

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

Answers