Skip to main content
Topics#Reports & DashboardsFrage von Eric Dreshfield
Eric Dreshfield (Dresh For Success LLC) fragte in #Reports & Dashboards
26. März 2013, 22:08

How can I get the average of percentages in a summary report ?

Here's my dilema:  I've got a custom summary formula that calculates a percentage and it works fine at the lowest grouping level, but I need to determine the average of  that percentage over all the lowest grouping levels at the level just above that.  (I know, that's confusing...perhaps this screen shot will help some.)

 

How can I get the average of percentages in a summary report ?

 

Anyone got any ideas ???

 

Thanks !
3 Antworten
  1. Eric Dreshfield (Dresh For Success LLC)
    27. März 2013, 01:25
    Here's the CSF:

     

    IF(round(((Cycle_Plan_Detail_vod__c.Actual_Primary_Details_mjn__c:SUM + Cycle_Plan_Detail_vod__c.Actual_Secondary_Details_mjn__c:SUM )  /  ( Cycle_Plan_Detail_vod__c.Planned_Primary_Details_mjn__c:SUM + Cycle_Plan_Detail_vod__c.Planned_Secondary_Details_mjn__c:SUM )),2) >1,1,(round(((Cycle_Plan_Detail_vod__c.Actual_Primary_Details_mjn__c:SUM + Cycle_Plan_Detail_vod__c.Actual_Secondary_Details_mjn__c:SUM )  /  ( Cycle_Plan_Detail_vod__c.Planned_Primary_Details_mjn__c:SUM + Cycle_Plan_Detail_vod__c.Planned_Secondary_Details_mjn__c:SUM )),2)))

     

    and a screen shot of the setting:

     

    Here's the CSF: IF(round(((Cycle_Plan_Detail_vod__c.Actual_Primary_Details_mjn__c:SUM + Cycle_Plan_Detail_vod__c.Actual_Secondary_Details_mjn__c:SUM ) / ( Cycle_Plan_Detail_vod__c.

     

    Here's a screen shot of the filters I'm using:

     

    User-added image

     

    and a screen shot of the sample report:

     

    User-added image

     

    Any more ideas ?
Antwort schreiben...
0/9000