Hello everyone,
In reporting, how do I get it to color the value red if match factor is below 950 and resolution is below 1,2?
Find maintenance, best practice, and troubleshooting articles.
Hello everyone,
In reporting, how do I get it to color the value red if match factor is below 950 and resolution is below 1,2?
Hello,
You would need to use conditional formatting on the table column to change the background or font color. In the case of the spectral match there is another field called Compound_SpectraConfirmResult which returns a 1 for peaks the meet the method match factor limit and 2 for peaks that do not. To test the resolution, you would just add the numeric values for the limit or use a report parameter if you change the limit often. You can search the help for conditional formatting to get more information.
Marty Adams
Hello,
You would need to use conditional formatting on the table column to change the background or font color. In the case of the spectral match there is another field called Compound_SpectraConfirmResult which returns a 1 for peaks the meet the method match factor limit and 2 for peaks that do not. To test the resolution, you would just add the numeric values for the limit or use a report parameter if you change the limit often. You can search the help for conditional formatting to get more information.
Marty Adams