How to make expression to only show overhead labor over 40 hrs/ week
Hi,
I want to make an expression that shows only Employee Overhead labor that is greater than 40 hrs a week. I am using an excel spreadsheet as the data source and have a Descrtion field that contains a list of all labor charge types. Presumably, I would add "ifs" to my expression to include those pertaining to voerhead hours, and once that is calculated, I would need the expression to then say, if overhead hours for a given week are greater than 40 hours, then display, if less than 40 hours or equal to 40 hours do not display.
Currently I have a chart that shows all employee overhead labor but team using ti would like to drill down further.
Here is the current Expression:
COUNT([Ovhd Hrs])
I am not sure how to aggregate this, any tips are aprpecaited.