When you say, "not working", that can mean 100 things.
Are you getting an error message? Wrong results?
I see a COUNT in there. Are you getting the aggregate/non-aggregate error message when you create the calc?
You probably want to do a SUM([Task completed with +ve]) when you subtract it from COUNT[Projects])
Yes you are right already I added that and I am getting substraction correct but while I am dividing that with Total Completed task
I am not getting correct result,it is showing as 1 for all
You can see the last column(Cal)
(Total Completed task-Sum(Task completed with +variance))/Total Completed task
I can suggest only one thing before I ask to see an actual workbook:
Format [Cal] to have some decimal places. Right now, every result there would round up to 1.
Now I got it
thanks for your support