Do you have any sample data ? I think what you're trying to do is:
IF sum([Hours]) >= 0 and sum([Hours]) <= 2 THEN "Total Overtime" ELSE "Incidental Overtime" END
That will return "Total Overtime" when sum([Hours]) is 0-2 (inclusive), but any negative number or number above 2 (so 2.0000001 and up ) will be Incidental Overtime.
Hi James ,
The calculate fields that you have created is having logical error. Please refer to Chris's calculation which looks perfect and I am sure it will serve you purpose.
Your ranges are overlapping with each other. There will be some elements of >0 that would be also part of > 0 and <=2.
Thanks and Regards,