2 Replies Latest reply on Jul 31, 2013 8:38 AM by Philip George

    Calculation using ratios and total value

    Philip George

      Hi,

       

      I have a data set like this.

       

      RoleEmp NameDomain
      PMababc
      BAbcdef
      DLdedfg
      TLadsdf
      PMacfgh
      BAafert
      DLasgfh
      TLamhjk

      .......          ......          ........

      I need to apply a ratio distribution on this Role to find out the ideal count of employees for this role.

      PM:BA:DL:TL ratio should be 1:1:3:15

       

      I want to display a graph which shows the ideal values applying this ratios against the roles..

      Ideally the calculation should be ((1/20)*totalcount of emp name.There are some other filters active which will dynamically change the total count of emp name.Here how will I store the total count of emp name and how to create calculated field which shows the ideal values for different roles.

       

      Regards,

      Philip