Convert Cell Formula to Column Unavailable

Ariane

Hi,

I want to convert this formula to a column formula, but it's greyed out and won't let me.

=[Baseline Duration]@row - Duration@row

I'm trying to get a duration variance in my schedule. Both columns are type Duration. The formula seems to work fine in the cell.

Thanks!

John Shane

@Ariane

Unfortunately, certain types of columns do not support column formulas and Duration is one of those. Is there another type of column you can use in its place?

Cheers,

John

Ariane

Ah that makes sense. I'm not sure what else I could use. I'm trying to understand the difference between the planned duration and the actual. I wonder if there is a way to get rid of the right most character (d or w) and then do a formula with the raw numbers?