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.

Find more posts tagged with

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.