Skip to main content

Hi SF Community,

I wrote a formula to track our implementation timeline however I'm getting some weird results when we look at the data.

Formula field not calculating correctly

 

User-added image

With Delta Plastics, it's calcuating a negative number, data below:

Onboarding Start Date:11/21/2016

 

Implementation Paused: 1/1/2017

 

Implementation Restart Date: 12/17/2018

SB Account Created Date: 4/27/2018

 

Why am I getting a negative 193 timeline?

Thank you!

 

-Drew
1 réponse
  1. 26 sept. 2018, 15:22
    Hi Drew,

     

    Based on the way your formula is written its return the right numbers.

     

    Do you mean to right the formula other way around

     

    Implementation Restart Date - SB Account Created Date

     

     and

     

    Onboarding Start Date - SB Account Created Date
0/9000