Forum Discussion

OhLookAnError's avatar
OhLookAnError
Icon for Helper I rankHelper I
3 years ago
Solved

How to return a zero when subtrahend is blank

I am trying to acurately display days since opened and days since closed in calculated columns. My days since closed column which is:     Days Since Closed = tblAccounts[Todays Date] - tblAccounts[...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi OhLookAnError 
    Please try

    Days Since Closed =
tblAccounts[Todays Date]
    - COALESCE ( tblAccounts[Account Closed], tblAccounts[Todays Date] )
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi OhLookAnError 
Please try

Days Since Closed =
tblAccounts[Todays Date]
    - COALESCE ( tblAccounts[Account Closed], tblAccounts[Todays Date] )
OhLookAnError's avatar
OhLookAnError
Icon for Helper I rankHelper I
3 years ago

Worked, Thank you!