Calculate variance

[#1]

I need to calculate variance of inprogress task where actual value has crossed  90% of estimate value. i've attached the sample file

fields to show:

taskname, percentage complted, actual value, estimated value , calculated variance

[Anonymous]

if(Sum([Act Value])>(Sum([Est Value])*0.9),Sum([Est Value])/Sum([Act Value]))

[#3]

Thanks for replying.... this is calculating variance for all all records...I want to see only those records in which actual value has crossed 90% of estimate value.... can i get the variance only for those records....

[Anonymous]

The 'if(Sum([Act Value])>(Sum([Est Value])*0.9)...' test is intended to make that restriction for you, with nothing generatd if that condition is not meet. I may be missing the point though.

Jonathan

[#5]

thanks i think it shud work....

[Anonymous · Accepted solution]

Is this answered now ? I think you marked the wrong post as a helpful answer (i.e. one of your questions)

Jonathan

[#7]

thanks yes it worked for me....