Format CPI column to more decimal places

[Strasser]

My CV% is -25%. I expected the CPI to equal .75, but instead it seems
rounded up to .8.
Does anyone know a way to format the CPI to show hundredths?

Thanks, in advance.
Strasser

 

[JulieS]

Hi Strasser,

I am showing hundredths in the CPI field by default. If you add a spare
number field and create the formula for CPI (bcwp/acwp) do you see .8 as the
answer? What are your values for bwcp and acwp?

I hope this helps. Let us know how you get along.

Julie

 

[Strasser]

Hi Strasser,

I am showing hundredths in the CPI field by default.  If you add a spare
number field and create the formula for CPI (bcwp/acwp) do you see .8 as the
answer?  What are your values for bwcp and acwp?

I hope this helps.  Let us know how you get along.

Julie






- Show quoted text -

Good idea.
But, didn't work.

I inserted Number1 field and created the formula [bcwp]/[acwp].
Returned .8 not the .75 I hoped for.

I can't remember changing any global format to round to tenths instead
of to hundredths.
Any other suggestions?
Strasser

 

[JulieS]

Good idea.
But, didn't work.

I inserted Number1 field and created the formula [bcwp]/[acwp].
Returned .8 not the .75 I hoped for.

I can't remember changing any global format to round to tenths
instead
of to hundredths.
Any other suggestions?

-Strasser
========================
What are your values for BCWP and ACWP? Do you see any other CPI
calculating to two digits? To the best of my knowledge, there are
no user changeable options that would change CPI. You can change
the number of decimal places for Cost values through Tools >
Options, view tab. But in testing, that did not change the CPI
values.

I hope this helps.

Julie