Skip to main content

23 feb 2015, 13:41

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 risposte

Greg Rohman (PrestigePEO)
23 feb 2015, 14:42
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

Aggiungi un commento

Scrivi una risposta...

0/9000