February 9, 200520 yr I can't figure out how to get the rounding feature to work. The caluculation is working fine: Percent of probability * $ scope of project = Weighted Expectation 100 375 37500 need for weighted expectation to display only (000's) result should be 375 How can I get the figure rounded properly? Thanks for your help.
February 9, 200520 yr You want the result to display only thousands? Then it should be 37.5 in your example. A suitable calc could be Percent of probability * $ scope of project / 1000. Rounding doesn't seem appropriate here.
Create an account or sign in to comment