K
k42
Guest
I'm trying to do conditional formatting on a calculated field in a report and it's not working. The field is a simple calculation:
=[SumOfTime Worked]-40
It comes up with the right answer, but I'm trying to make it disappear when it's a negavite value, so I wanted the font color to be white if the value was less than 0, but it's only making the value white when the value IS 0. Anyone have any ideas?
=[SumOfTime Worked]-40
It comes up with the right answer, but I'm trying to make it disappear when it's a negavite value, so I wanted the font color to be white if the value was less than 0, but it's only making the value white when the value IS 0. Anyone have any ideas?
