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 nega...
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

Interkoubess's avatar
Interkoubess
Icon for Solution Sage rankSolution Sage
8 years ago

Hi islandtime,

 

Please try this formula :

 

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

Hope it helps...

 

Ninter