2 Replies Latest reply on Sep 11, 2016 11:01 AM by shannon Dempster

    Help!  Calculating a % with an aggregated and non-aggregated number

    shannon Dempster

      Hi!  I'm trying to create a % based on information from two data sources - one is an aggregated number and the other is not.

       

      Scheduled to Actual is the main data source

      RM UTIL is the secondary

       

      I want to aggregate the scheduled hours in "Scheduled to Actual" and divide by "available hours" in RM UTIL.

       

      For example, in September:

      John Doe has 152.690 scheduled hours

      I want to divide that by 176 available hours from the secondary data source.

       

      152.69 is aggregated

      176 is not

       

      i'm looking for it to show 86.8% but it's aggregating all of the available hours to 2,088 and making it 7%

       

      is this possible?!  I've been trying for hours!!!
      !!!!!!!

       

      THANK YOU for your help!!!!!!!!!!!!!!!!!!!!