A number minus 0 is showing negative

BFuller

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!

Hollie Green

Which column indicates the actual logged hours and which indicates the allotted hours. Just based on the column names it appears they are backwards and should be

=SUM([Hours in Funnel with CDR Due Date]@row-[Actual PCD Touch Time logged Active Projects]@row)

Hollie Green

Which column indicates the actual logged hours and which indicates the allotted hours. Just based on the column names it appears they are backwards and should be

=SUM([Hours in Funnel with CDR Due Date]@row-[Actual PCD Touch Time logged Active Projects]@row)

BFuller

yes, that was it. Goodness…I am just so hyper-focused on this that I can't see the forest through the trees! Thank you so much!