Training Adherence - I keep getting Invalid Data Type - Help!

ashly.summers

I am trying to determine the difference between Duration and Actual Duration so that we can more wholistically view how we are with doing training in the time frame assigned.

=VALUE([Actual Duration]@row ) / VALUE(Duration@row )

Paul Newcome

Try this:

=VALUE(SUBSTITUTE([Actual Duration]@row, "d", "")) / VALUE(SUBSTITUTE(Duration@row, "d", ""))