Discussions

 View Only
  • 1.  Report Filter Not Working

    Posted 05-03-2022 17:14
    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
    ------------------------------


  • 2.  RE: Report Filter Not Working

    Posted 05-03-2022 17:49
    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
    ------------------------------



  • 3.  RE: Report Filter Not Working

    Posted 05-04-2022 11:45
    Thank you so much!! That helped.

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