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!
Carlos
답변 2개
Hi Carlos,
Date/Time field and Shift Report Number and Record Count1 fields, are they all on the same object?
