Report filtering is not returning data I expect it to
![PeggyLang](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives