AnsweredAssumed Answered

calculation fields

Question asked by storywizard on Jun 21, 2010
Latest reply on Jun 25, 2010 by LaRetta_1

Title

calculation fields

Post

Hello all:

 

I am just starting work on a couple of calculation fields. I am really new at this

.Attached is my layout. Here is a description of the calculations, one is fairly simple, the second one is a mind bender for me, anyway...

 

1: The Lead time field, which will be the PartDueDate  minus the DateSubmitted


2: The PartStatus field which has one of four results, each with a different colour...

  1. If DateCompleted is blank and DueDate is not passed then PartStatus will be InProcess 
  2. If DateCompleted is blank and DueDate is passed then PartStatus will be OverDue 
  3. If DateCompleted has a date that is on or before DueDate then PartStatus will be Complete 
  4. If DateCompleted has a date that  is after DueDate then PartStatus will be CompletedLate

 

Any help as I make my way through this will be greatly appreciated as always...

 

Storywizard




Outcomes