Skip to main content
Topics#Reports & DashboardsDomanda di Rose Sherman
Rose Sherman ha fatto una domanda in #Reports & Dashboards
30 gen 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 risposte
  1. Ritika Bhargava (Freelancer)
    30 gen 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.
Scrivi una risposta...
0/9000