Forum Discussion

BrandyNunes1's avatar
BrandyNunes1
Qrew Member
3 years ago

Report Filter Not Working

I have a report that filters on specific fields, so that when the record is ready to go to the next phase of processing, it shows up on this report. I am having issues with records that don't meet the requirements, but are still showing up. 

Below is a screen shot of my filter.

So if a record has a job number, is not 100% billed out, but is 100% complete and has contract terms of A. 100%, then it should appear on my report. 

However I have records that are 100% complete and 100% billed out showing up.

Please help!

Thank you,

Brandy


------------------------------
Brandy Nunes
------------------------------
reports and charts

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    Similar to Excel, when you have a value displayed as a Percentage it is actually stored as a value typically between 0 and 1.  That will display respectively as 0% and 100%.

    So you need your report filters to compare with 1 (and not 100 and not 100%)

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • BrandyNunes1's avatar
      BrandyNunes1
      Qrew Member
      3 years ago
      Thank you so much!! That helped.

      ------------------------------
      Brandy Nunes
      ------------------------------