FY09 Labor Hours 21014 No_Task_A 12385 USD Actual_Project
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
A Tot_Project Proj_Countz 30 31 31 31 27 29 25 25 24 28 25 24
Tot_Project Man_Mos 0.9996 1.0007 0.9999 0.9992 1.0001 0.9995 0.9994 1.0004 1.0001 1.0003 1.0004 1.0004
Basically I am trieng to achive the Total Man Mon/Total project =0.9996/30.First I calculated the count of the Project Dimension and stored in Proj_countz member then the Man_Mon values are loaded from source.
next we need to calculate Avm=Man_Mos/Proj_Countz->A. The Rank is Attribute dimension similarly we have to calculate for all the different Ranks (A,AA,etc) .I have tried to write the below calc but giving me the same value of Man_Mos It is not giving me a correct result hence please help me to resolve this issue.