Skip to main content
Topics#Reports & DashboardsQuestion de Rose Sherman
Rose Sherman a posé une question dans #Reports & Dashboards
30 janv. 2017, 22:38

Span of months in a grouping

I have a report of students age in months.  It is grouped by classroom.  I need to calculate the span of months between the youngest student and the oldest student in the class   I have looked at using PREVGROUPVAL however I cannot predict the increment value because one class could have 10 students while another could have 8.  

 

The data looks like this:

 

Classroom, Student, Age in Months

 

Mr. Allen, Abigail Adams, 223

 

Mr. Allen, Bob Baxter, 241

 

Mr. Allen, Cali Conwed, 250

 

Mr. Allen's class:  Age Span: 27

 

Ms. Bowen, ............

 

Is there a way to do this in Salesforce, or does it need to be done in Excel?  

 

Thanks! 
3 réponses
  1. Ritika Bhargava (Freelancer)
    30 janv. 2017, 22:54
    To check on the difference between minimum and maximum Age Span, simply utilize a formula on report and provide its Grouping Level at 'Grand Summary Only'

     

     

    Student.Age_Span__c:MAX - Student.Age_Span__c:MIN

     

    PS. Please replace the fields and object names appropriately on the report.
Rédiger une réponse...
0/9000