Forum Discussion

islandtime's avatar
islandtime
Frequent Visitor
8 years ago
Solved

formula to convert null to zero

 I have created a custom column that subtracts two dates (Completed Date - Due Date), to give a whole number. 

 

I would also like to add to this custom colum a conversion that changes all the negative numbers to zero, i.e. everything appears as a zero unless the item was completed past its due date. 

 

Can anyone give some pointers on how I might achieve this?

 

 

 

Need Help
  • Interkoubess's avatar
    Interkoubess
    8 years ago

    Hi islandtime,

     

    Please try this formula :

     

     
    =if (Due Date>Completed Date ,0,Completed Date -Due Date)

    Hope it helps...

     

    Ninter

1 Reply

  • Interkoubess's avatar
    Interkoubess
    Solution Sage
    8 years ago

    Hi islandtime,

     

    Please try this formula :

     

     
    =if (Due Date>Completed Date ,0,Completed Date -Due Date)

    Hope it helps...

     

    Ninter