0 Replies Latest reply on Oct 31, 2011 5:30 PM by 821696

    How to pickup the Attribute Value

    821696
      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.

      "Avm"(
      IF(@ISMBR("Tot_Project",@Attribute(A)))
      Avm=Man_Mos/Proj_Countz
      ENDIF;
      )

      Thanks,
      Irsh