Comparison Function

When you are working on a Custom Analysis, on the Filter tab, you have the option of using the Comparison function:

mceclip1__7_.png

This can be used to compare any two columns of the same type such as two columns that display numerical values. You might use this function if you wanted to see the jobs were Billable Hours exceed Budgeted Hours. 

To do this, you would set the parameters as shown above. Set Filter Column to "Budgeted Hours", Comparison to "<", and Value to "Billable Hours". When applied, the table will filter the data to show jobs where Billable Hours exceed Budgeted Hours. If you reverse the Comparison field to ">" the table would shoe jobs where Budgeted Hours exceed Billable Hours. 

Was this article helpful?
0 out of 0 found this helpful

Still looking for your answer? How Can We Help?