Forum Discussion
Solved
Checking multiple columns against a variable
I have the following table Employee Week 1 Week 2 Week 3 Week 4 Standard Jack 40 40 40 40 40 Tommy 40 40 32 32 32 Amy 25 25 25 25 25 Steve 42 42 40 40 40 ...
It's using SUMX which works one value at a time, and sums the expression given, not the raw value.
The expression says "if non-compliant, output a 1 otherwise 0". When we sum that, if it is 0 then all of the values must have been compliant.
Since you allow hours to be over, the check should be [Value] < [Standard] but the principle works.
