Forum Discussion

calen's avatar
calen
Icon for Helper I rankHelper I
5 years ago
Solved

Filter is Filtering Too Much

Hello All!   I have been searching for about a week and have not found a fix to this problem. I'm hoping someone can point me in the right direction.    I have a report that compares current year...
Need Help
  • calen's avatar
    calen
    5 years ago

    Pragati11 Thanks for your help with this! It helped shift my train of thought which helped me solve it! I went to my data queries by clicking "Transform Data". From there I applied the filter. For some reason it works when applying the filter there instead of on the page level. 

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
5 years ago

Hi calen ,

 

Can you tell which column in your journal entries has a decription = "Close Income"?

Because there are for sure something getting filtered based on your Page Level filter.

 

Please share some sample data with all the columns used above.

 

Thanks,

Pragati

calen's avatar
calen
Icon for Helper I rankHelper I
5 years ago

Hello Pragati11! The description column is the one I'm flitering on that contains "Close Income". As you see below, we do a journal entry on the last day of the year which has this in the description.