number of days past due  change to positive number
Hello 
I have this formula  =IF(COMP@row = "X", 0, [DUE DATE]@row  TODAY()) in a column entitled "Aging".
If a user marks an item complete with an X, then nothing appears in the aging column. If the due date is in the past by thirty days, the formula produces a 30. If the due date is in the future by 30 days, the formula produces 30.
I'd like the formula to produce nothing if the due date hasn't past and a positive number, not a negative in the Aging Column so if it's thirty days past due, the column will have 30, not 30.
If anyone can help, thanks in advance!
Lisa
Comments

Solved my own issue, I guess coffee hadn't kicked in yet 
=IF(COMP@row = "X", 0, TODAY()  [DUE DATE]@row)

Hey Lisa,
Glad you found a solution. I was going to suggest wrapping your formula with the ABS() function to return the Absolute Value (30). Yours looks much cleaner.
 Jeremy