Skip to main content

Feb 23, 2015, 1:41 PM

Formula to divide number value in Bucket by the tota number of records

Formula to divide number value in Bucket by the total number in RowCount. I have tried amongst others, but I cannot get iit to work.

IF(BucketField_81320107= "YES", 0/ RowCount, 0), but that does not work

8 answers

Greg Rohman (PrestigePEO)
Feb 23, 2015, 2:42 PM
Hi Phil.

Rather than use a bucket field, you might consider using a formula field on your object to calculate YES or NO, and perhaps use the Power of One technique (credit to Tom Tobin) for your reporting:

https://success.salesforce.com/ideaView?id=087300000006tdeAAA

http://crmology.com/2012/10/22/reporting-accurate-record-counts/

-Greg

Add a comment

Write an answer...

0/9000