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.