Report Filter Not Working

Question

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
------------------------------

MarkShnierYou · Answer

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
------------------------------

Sign up

Login to the community