Calculations based on timelines

Question

Hello! I’m being asked to create a report where we can see if a project is adhering 75% to the original timeline. I thought about creating a custom field based on a formula which would divide $BaselineDuration by a value that is calculated from a field with the formula DateDiff($BaselineDueDate,$ActualEndDate,’d’). I get an error when doing this,  “Error: Data types Numeric and Duration not compatible for '/' operation” If I try to save DateDiff($BaselineDueDate,$ActualEndDate,’d’) as a duration instead of a numeric value, I get the error: Error: Formula evaluation result data type is Numeric instead of expected Duration.

zfieldsgreystar · Accepted Answer

Hi Eric,It sounds like the Field Type for your custom field is Duration which is where “data type is Numeric instead of expected Duration” is from. Have you tried creating this as a Numeric or Percent field type?-ZF

eric.abonce · Answer

Thank you so much @zfieldsgreystarand @Andy Johnston!Indeed, all I had to do was to create a numeric customfieldthat “converts”the amount from the duration field that I wantto use in the calculation into a numeric value; I used the formula($BaselineDuration / Days(1) ) for this.

Planview Customer Community

Login with SSO

Planview Customer Community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded