Skip to main content
Hello all!

 

I am trying to build a formula in a Report to get the (total number of Records) / (# of Groupings). 

 

Looking at the PrtSc below, we can see that I have 9 Records and 5 Groupings (Date/Time).I would like to have a formula (or another solution) that computes: (total number of Records) / (# of Groupings) = 9/5.

 

Do you know if this can be done ? I have already installed the Power of One (field Record Count 1) as you can see in the Picture, but I am not able to find a solution for this problem.

 

Thanks in advance!How to divide the total number of Records by the # of Groupings

 

Carlos
2 risposte
  1. 25 apr 2018, 12:42
    Hi Carlos,

     

    Date/Time field and Shift Report Number and Record Count1 fields, are they all on the same object?

     

     
0/9000