Skip to main content

The "Power of One" technique

First bow and give thinks to the DemiGod of Analytics Tom Tobin.

Then create a new custom field on every object that you want to report on.

Select:

Datatype = FORMULA

Result = NUMBER (0 decimals)

Formula = 1 that's it, just a number one.

Then add the new "Power of One" fields to your reports and select Summarize(SUM) and behold!

162 comments
  1. Aug 20, 2019, 9:08 PM
    @Ashley Gerson

    I use a formula on the Contact object to display an image if certain fields are populated. What it does is assigns a score if the field value is blank.

    My requirement was that I wanted to populate a value beside each field as a score so that I could display a 5 star rating system on the contact page.

    I think this migt qork for you if you modify the formula to your fields.

    If(ISPICKVAL( Salutation , ""),0,10)+

    If(ISBLANK(FirstName),0,10)+

    If(ISBLANK( ReportsToId ),0,10)+

    If(ISBLANK(Title),0,10)+

    If( ISPICKVAL( Title_Category__c , ""),0,10)+

    If(ISBLANK( Mailing_Street_1__c ),0,10)+

    If(ISBLANK( Mailing_Street_2__c ),0,10)+

    If(ISBLANK(Email),0,20)+

    If(ISBLANK(Phone),0,10)

0/9000