Post

1 follower Follow
0
Avatar

Calculate an end date based upon current progress

Attempting to create a report highlight that will show the calculated end date of a particular task based upon maximum current variance.

Filter: $State=’Active’

Var1: Max $DueDate

Var2: Min $DueDate

DateAdd((FindObject(1430,$C_Index,$DueDate)))(DateSubtract(var2,(DateAdd(var2,(DateSubtract(Today(),var1)))))*-1))

Getting syntax error from the FindObject function

Add (due date from task with index #1430 <-custom field) to (variance from active minimal task date and active maximum task date)

Any help with the formula or a better way to display the highlight will be greatly appreciated.

Dennis Miller

Please sign in to leave a comment.