A number minus 0 is showing negative
Hello, I have a group of people who have a certain number of hours to complete a project. When they have yet to log time against that project, the logged time column is showing 0. Then, my formula finding the sum of the number of hours allotted (5 for example) minus the number of hours logged (0 for example) is showing as negative (-5). But I need it to be just 5. How can I fix this?
Here is my formula: =SUM([Actual PCD Touch Time Logged Active Projects]@row - [Hours in Funnel with CDR Due Date]@row)
Many thanks in advance!
Help Article Resources
Check out the Formula Handbook template!