• Liubov Korneva 5
  • NEWBIE
  • 0 Points
  • Member since 2017

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies

I have a custom object where I am attempting to count and "Lock In" the number of days that a record sits at each of the 5 or 6 Stages in our process.  I used this formula, but it's not producing the results I need: 

Today() - Job_Status_Change__c

 

Here is an example of what my formula is producing for a Job that has on it's 50th day:

 

Stage 1 50

Stage 2 50

Stage 3 50

Stage 4 50

Stage 5 50

 

Here is what that very same project Stage Duration will reflect should I create the correct formula:

 

Stage 1 5

Stage 2 9

Stage 3 4

Stage 4 12

Stage 5 19

 

* the aggregate days for this Job is still 50 days, but the formula has captured the total number of days this Job sat at each of our Stages. 

 

Any suggestions?

 

Thanks in advance for you help. 

 

 

  • July 09, 2010
  • Like
  • 0